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

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

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

Private Sub Workbook_Open()
ThisWorkbook.Worksheets(Format(Date, "dd.mm.yy")).Activate
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
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