topic Re: Need help with Excel Macro in Operating System - Microsoft

Need help with Excel Macro

Vadim Loginov — Tue, 03 Jun 2008 12:18:01 GMT

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

Re: Need help with Excel Macro

Jon Finley — Tue, 03 Jun 2008 22:55:17 GMT

Try something like the following:

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

Jon

Re: Need help with Excel Macro

Vadim Loginov — Fri, 06 Jun 2008 07:52:03 GMT

Hi Jon,

Thanks for pointing me to the right direction.

V.