Automatic log on to website and download report using VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • exporting to CSV
    ... Some people instead of reports want Comma Seperated Files. ... trying to find a good way of outputting to csv with using either sql ... I used bcp using the master.dbo.xp_cmdshell command to output the ... The problem with that is that the bcp executes the stored proc ...
    (comp.databases.ms-sqlserver)
  • How to use ruby, csv and webservice? Need a direction.
    ... I have an app that does inventory and I also created a bunch of reports ... All of my reports can produce: xls, csv, pdf ... I can have a copy of my app running on my scheduling computer that I ...
    (comp.lang.ruby)
  • Re: Automatic log on to website and download report using VBA
    ... 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 ...
    (microsoft.public.excel.programming)
  • Another parcing question
    ... I am provided a CSV txt file from an Oracle DBS. ... I import it into Access so I can perform reports and other actions. ... for multimedia design services visit http://www.legalanimatics.com. ...
    (microsoft.public.access.queries)