none
Microsoft Edge Reference Library? RRS feed

  • Question

  • Windows 10 Access 2010. What is the Available Reference for the Microsoft Edge web browser to be used in a VBA project?


    peter n roth - http://PNR1.com, Maybe some useful stuff

    Thursday, February 21, 2019 10:36 PM

Answers

All replies

  • There is none, as far as I know...

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Peter N Roth Friday, February 22, 2019 9:34 PM
    Thursday, February 21, 2019 10:48 PM
  • What exactly are you trying to do?

    Why not use IE automation?


    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    • Marked as answer by Peter N Roth Friday, February 22, 2019 9:34 PM
    Friday, February 22, 2019 12:15 AM
  • Perhaps something with which to explore the DOM? Perhaps another browser?

    peter n roth - http://PNR1.com, Maybe some useful stuff

    Friday, February 22, 2019 12:15 AM
  • Daniel & Hans -

    i'm trying to read a webpage using the HTML elements. I've already hacked the page using string processing, but I'm looking for some elegance.

    i'll check out IE automation as you suggest. 


    peter n roth - http://PNR1.com, Maybe some useful stuff

    Friday, February 22, 2019 1:11 AM
  • i'm trying to read a webpage using the HTML elements. I've already hacked the page using string processing, but I'm looking for some elegance.

    Hi Peter,

    What is wrong with the string processing? Until now I am quite happy with it.

    Is the "elegance" that you are looking for that the program can automatically determine how many columns there are in a table? Or things like that?

    With the many possibilities that the designer of HTML pages has, it will become a complcated program, I fear. But also, the many different items that can be mixed on a web page will make the reverse engineering hard.

    Some general string manipulation tools and some placeholders do the job for me.

    Imb.

    Friday, February 22, 2019 9:01 AM
  • Hi imb –

    Well of course there’s a little more to it than elegance. The idea is controlling a page. The page I’m working on used to be sortable, but the new “improved” page requires sorting be done manually. Really!

    I read the page with the string functions, pull everything into an Access table, and then sort it on my own machine.

    What I want is to sort it on the site. The string functions don’t give me the opportunity (as far as I know) to fill textboxes with text, click buttons, etc.

    Whereas, with an element on the login page like this

        Dim em As Object
        Set em = ie.Document.getelementbyid("email")
        em.Value = userid
    
    I'm on the way to having some control.

    peter n roth - http://PNR1.com, Maybe some useful stuff

    Friday, February 22, 2019 3:11 PM
  • What I want is to sort it on the site. The string functions don’t give me the opportunity (as far as I know) to fill textboxes with text, click buttons, etc.

    Hi Peter,

    I am not yet on the right track. You have a webpage, you want to modify this webpage by sorting some column or table, and then? Replace or store the modified page for the users?

    In my applications I just do the grabbing, to gather the "information" on the page. E.g. to collect the exchange rate for certain currency, and store it directly in an Access table. Or to couple (almost) automatically the name of a movie in a table to the IMDb, by grabbing the corresponding ID. After grabbing, you can manupilate the data at will.

    No work on modifying webpages.

    But a very interesting subject...

    Imb.

    Friday, February 22, 2019 4:15 PM
  • Aha! Not my webpage. I want to rearrange their web page, that contains my data.

    I get their presentation of my stuff, I sort it my way, and I post it back to their site. The hooks are there.

    That’s the idea, anyway.


    peter n roth - http://PNR1.com, Maybe some useful stuff

    Friday, February 22, 2019 9:33 PM