Hi,

Scenario is spreadsheet No. 1 has a macro that opens spreadsheet No. 2
and then saves and closes sheet No. 1 - that all works ok - but I then
need the macro go move the cursor to a particular cell and worksheet
in spreadsheet No. 2 - this is where I'm having problems although
sheet No. 2 is the only sheet open my sheet select and application
goto reference commands seem to be ignored

I'm guessing that although only 1 sheet is open I still need to make
this the active sheet

Thanks if you can help

Regards

splowe



Sub OpenOld()
'
' OpenOld Macro
' Macro recorded 08/04/2005 by Steve Lowe
'

'
ChDir "C:\My Documents\steves stuff\journal"
Workbooks.Open Filename:= _
"C:\My Documents\steves stuff\Journal\Old-Combined.xls"
Windows("CurrentMonth.xls").Activate

' OK Now lets close and save the current diary

' First we need to go back to the data worksheet
' in the current diary as we are currently in the macro worksheet

Sheets("Sheet1").Select

' Now lets save and close the workbook

ActiveWorkbook.Save
ActiveWorkbook.Close

' Now lets go to the 1st real cell in the old historical work sheet



Sheets("X Days Ago").Select
Application.Goto Reference:="AdjLookBack"
Range("A5").Select



End Sub
- Steve Lowe
- E-Mail :
- Before Replying Remove .NO.SPAM
- UK Resident although my e-mail address is usa.net