View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Automatic log on to website and download report using VBA

What kind of login: textboxes on the page or a separate popup dialog?

Tim

"Hari" wrote in message ups.com...
Hi,

I have to pull out some reports from my company's intranet web-site (a
reporting system) in CSV format on a regular basis and this CSV file is
further proceesed using some macros written by me. I would like to
automate the process of generating this CSV in the first place.

Is it possible to log in to web-site, click on a particular link for
downloading a report and save it with new name in a specified location
on my hard drive using Excel VBA only?

Please give me some pointers. I will be glad to give more information
if required.

Regards,
HP
India