Hmmm...
Does the workbook have to stay closed?
Is it always in the same location?
I have used something before along the lines of:
Code:
Application.Workbooks.Open ("temp1.xls")
Workbooks("temp1.xls").Worksheets("Sheet1").Activate
'Do some stuff
Activeworkbook.Close
However, this is not very efficient programming as it is slow , going back and forth between workbooks like this!
Hope this is of some use.
Dunkay.