View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] grantmcewan@austin.rr.com is offline
external usenet poster
 
Posts: 4
Default Opening explorer using VB

Hi,

I am a relative novice at VB programming, I have been writing some
code for excel to pull data in from an external file then manipulate
the data with some formulas etc..

I was wondering if there was any way that VB can open up an explorer
window, go to a certain URL and login with a username and password,
then navigate the site to a certain page and download a file ? I was
hoping I could automate that part of the process also rather than me
executing the file download and placing it in a certain server
location for my macro to find/open.

Thanks

GMc