View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GEORGIA GEORGIA is offline
external usenet poster
 
Posts: 16
Default can navigate through intranet site with Web Query (VB code?)?

Is there a way to create a web query, once logged in with user name and
password, navigate through the site to get the report into excel?
for example:
once logged into the site
I have to click on "Other Application" link
then clikc on " Accounts Receivable Management Suite"
then clikc on
"Standard Aging" then
click on "submit query"
click on the appropriate region (Hou, ATL..)
then clikc on " Aging - Text Download" ( this actually exports it out into
text file).
the intranet is created in frontpage.

Any help or suggestions will be appreciate it.
Thank you!
then click on