Need help with Excel Macro

[Vadim Loginov]

Hi,

I am wondering if there is any way how I can change Excel Macro code dynamically.
I am asking cos I’ve got the following task:

Each month I need to produce Excel spreadsheet with Macro.
Macro will perform the following function. It will import CSV files (hosted on http server) into a spreadsheet and produce some graphs. CSV files have dynamic name: like 200804.csv, 200805.csv. (If now is June, the latest CSV file is for May)

Any advice will be much appreciated.

Thanks
Vadim

[Jon Finley · Accepted solution]

Try something like the following:

=(TEXT(YEAR(NOW()),"????")&TEXT(MONTH(NOW())-1,"0?"))&".CSV"

Jon

[Vadim Loginov]

Hi Jon,

Thanks for pointing me to the right direction.

V.