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

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

Hi Tim,

Basically, I have to type in a URL in IE, which opens a webpage with
built in textboxes (no pop-ups) and once I provide my Login ID,
Password (in 2 different textboxes), then I have to press on a button
in order to actually enter the site.

The above process is done for 3 different web-sites for 3 different
reports and all of them have different complexities in terms of further
tasks to be done in terms of pulling out the actual report. Let me
detail the simplest report below.

In this once I log in to the web-site I just have to press on the
"Export" button in the far upper left and this brings up a new page, in
which there is a drop down box "Export Format" which has MS Excel
selected by default, then there is a textbox "Email recepients" in
which my official email address is already filled in and a checkbox
"Include table of contents" which is checked by default, a drop down
box "Export Scope" having 2 possible values, "Entire report" and
"current page" out of which, Entire report is selected by default and
finally one more dropdown box "Report Language" in which English
is enabled by default. Basically this page has relevant options already
filled or checked in it.

On the lower right hand corner there are 2 more textboxes "Ok" and
"Cancel" from which if I can click on OK then a new webpage opens
up which says that "The export task has been added to the queue, and
will be executed as soon as possible." and after a few seconds I
would get a mail in my Inbox with the concerned report.

If I can automate the above process of logging and clicking then I can
take it from there.

If a solution is possible for above, I will try to post in a report
which requires a little more interaction from user side.

Regards,
HP
India


Tim Williams wrote:
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

If you search Google groups for past posts in this group you'll find plenty of examples of logging in to a site.

Post back if you have problems with the other steps.

Tim

"Hari" wrote in message oups.com...
Hi Tim,

Basically, I have to type in a URL in IE, which opens a webpage with
built in textboxes (no pop-ups) and once I provide my Login ID,
Password (in 2 different textboxes), then I have to press on a button
in order to actually enter the site.

The above process is done for 3 different web-sites for 3 different
reports and all of them have different complexities in terms of further
tasks to be done in terms of pulling out the actual report. Let me
detail the simplest report below.

In this once I log in to the web-site I just have to press on the
"Export" button in the far upper left and this brings up a new page, in
which there is a drop down box "Export Format" which has MS Excel
selected by default, then there is a textbox "Email recepients" in
which my official email address is already filled in and a checkbox
"Include table of contents" which is checked by default, a drop down
box "Export Scope" having 2 possible values, "Entire report" and
"current page" out of which, Entire report is selected by default and
finally one more dropdown box "Report Language" in which English
is enabled by default. Basically this page has relevant options already
filled or checked in it.

On the lower right hand corner there are 2 more textboxes "Ok" and
"Cancel" from which if I can click on OK then a new webpage opens
up which says that "The export task has been added to the queue, and
will be executed as soon as possible." and after a few seconds I
would get a mail in my Inbox with the concerned report.

If I can automate the above process of logging and clicking then I can
take it from there.

If a solution is possible for above, I will try to post in a report
which requires a little more interaction from user side.

Regards,
HP
India


Tim Williams wrote:
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

Example:

http://groups.google.com/group/micro...72b7edf51f9976

Tim

"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
If you search Google groups for past posts in this group you'll find plenty of examples of logging in to a site.

Post back if you have problems with the other steps.

Tim

"Hari" wrote in message oups.com...
Hi Tim,

Basically, I have to type in a URL in IE, which opens a webpage with
built in textboxes (no pop-ups) and once I provide my Login ID,
Password (in 2 different textboxes), then I have to press on a button
in order to actually enter the site.

The above process is done for 3 different web-sites for 3 different
reports and all of them have different complexities in terms of further
tasks to be done in terms of pulling out the actual report. Let me
detail the simplest report below.

In this once I log in to the web-site I just have to press on the
"Export" button in the far upper left and this brings up a new page, in
which there is a drop down box "Export Format" which has MS Excel
selected by default, then there is a textbox "Email recepients" in