ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   can navigate through intranet site with Web Query (VB code?)? (https://www.excelbanter.com/excel-programming/335575-can-navigate-through-intranet-site-web-query-vbulletin-code.html)

GEORGIA

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




All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com