Hi there! ![Roll Eyes (Sarcastic)](https://www.excelforum.com/images/smilies/rolleyes.gif)
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
Bookmarks