running applications

[rcb]

From an Excel Macro, I need to pass a URL to IExplorer, log in to a site, and
then perform some commands to export data an Excel file.

This application will run on a scheduled basis (weekly, perhaps) to append
the data to Excel and process it.

Any ideas?

 

[joel]

It is a piece of cake to pass a URL to a webpage from VBA, it is no
that easy to get the data without seeing the webpage. Every webpage i
different anwithout know the exact data you need you need some help. Y
can find lots of example if you do a google search for

VBA EXCEL IE


If you add JOEL to the search you find plenty of examples that I hav
people with