On 9 Jan, 08:57, carlo wrote:
try this:

dim thedate as string

thedate = format(now(),"dd.mm.yy")

sheets(thedate).select

hth

Carlo

On Jan 9, 5:54*pm, wrote:



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- Hide quoted text -

- Show quoted text -

Thankyou both for the fast responses, they both helped.

many thanks