Hi All,

I would appreciate any help you can give me on this.

I have a worksheet in excel and on the click of a comand button it
opens another file and gets the values from the cells i want closes
that file and inputs the data to the relevant place in my sheet.

But, i want to be able to select a sheet when i open the file
according to a cell value / date. All the sheets in the other file are
named after the date so, 09.01.08 would be todays sheet name.

I have tried doing the following but it didnt like it:

Dim TheDate As String

TheDate = "=text(now(),""dd.mm.yy"")"

Sheets(TheDate).Select


Any ideas?

Many thanks in advance,

Ash