Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logging onto a website
Is it possible in a macro to go to a website (URL in say A1) and to
pass parameters like login name (in A2) and password (in A3), so that you could automatically log in to that website? If so, is it then possible to simulate mouse-clicks on subsequent pages, so that you could choose from options to get further into the site? Option choices could be listed in A4, A5 etc. so I could set this up for a variety of clients. Ultimately, what I would like to do is to print off a page (which might be an HTML page, but is sometimes shown in a PDF viewer) automatically. The page is a copy invoice for my client(s), and currently I have to log on to the supplier's website, then maybe select the client from a list, maybe select "View Invoices" from another list, and ultimately select the appropriate invoice from another list (usually in reverse date order). All of this takes a considerable amount of time just to get a paper copy (which used to be mailed to me, but suppliers now seem to prefer to give you web access to the invoices), so I'd be grateful if I can speed this process up. Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logging changes | Excel Discussion (Misc queries) | |||
inporting data from website where website address frequently chang | Excel Programming | |||
Logging a website information. | Excel Worksheet Functions | |||
logging out | Excel Programming | |||
Logging into a website | Excel Discussion (Misc queries) |