Dim statement for date month

[Ricardo9211]

I have a macro that pulls another workbook and the workbook changes the name from month to month. how can i use a dim statement that says use the current month and look for that months workbook

The format of the workbook is
"call off log Sept 2009"
"call off log Oct 2009
"call off log Nov 2009" ETC.

any ideas

[Bob Phillips]

No dim necessary

Please Login or Register  to view this content.

[shg]

I don't know what your trying to do, but to form a string like that

Please Login or Register  to view this content.

You would have to name the workbooks consistently, e.g, call off log Sep 2009, not call off log Sept 2009