importing external data from a website

[ppg]

Hi there!

I am trying to download a csv file from a website by using the import external data function. I have created a macro that does it but I want to generalise it. In the Macro below I would like that:

a) Instead of using ds090312fo (which stands for 12 March 2009)
to use the previous business day, i.e. today Monday we should use
090313 (13 March 2009)).

b) If I leave excel open to make it automatically so that the program runs
by itself everyday at 8.30 am.

Does anyone have a clue? Any help on the questions would be highly appreciated. THANK YOU VERY MUCH!

Pep

Please Login or Register  to view this content.

[ravishankar]

Hi
Try the macro attached
Ravi

[ppg]

Hi RaviShankar,
Thank you very much for your quick reply.

I have however a small problem when running the macro. If I .try to debug I go to the line:

Please Login or Register  to view this content.

which is the problem I was always getting. Do you happen to know whether this is a problem on the macro itself or in the settings?

I tried in different PCs but it did not work either.

Thanks a lot!

Ppg

[mudraker]

ppg

Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)

Please make sure you wrap your VBA code in both of your postings in this thread

[ppg]

Hi RaviShankar,

Thank you very much for your quick reply. Here below is the Macro that you sent me:

Please Login or Register  to view this content.

I have however a small problem when running the macro. When I run it the macro

crashes and if I try to debug it goes directly to the line below:

Refresh BackgroundQuery:=False

which is the problem I was always getting. Do you happen to know whether this is a problem on the macro itself or in the settings?

I tried in different PCs but it did not work either.

Thanks a lot!

Ppg