Hi unknown,

try:

Format(Month(Date), "MM")
Format(Year(Date), "YY")

you can use this as reference for your workbook to open
like:

workbooks.open filemane := "c:\some path here\"& Format
(Month(Date), "MM") & ".xls"

Best

Markus


-----Original Message-----
Hi,

this is a bit tricky, here goes...

I am working on workbook 'Sales 04 12m' and on
worsheet 'alpha 12m 04'.
I put a vlookup function that looks up data from a table
array in another
workbook for the previous month, which has the same name
format "Sales YY
MMm" and from a similar worksheet "alpha 11m 04'.

This macro I use in three different sheets in the
workbook I can's go
changing the names each time in the macro. I need a way
to specify the
workbook/worksheet from upfront. or even better beacuse
it is always one
month back, the macro could figure out the name by
itself , could it??

I tried InputBox inside the vllokup function but i get an
error, mayby I am
not supposed to use it that way.

Any help appreciated.

Thank you
.