scott56
08-19-2008, 02:04 PM
Hi,
I am running a command to convert some data in an Excel workbook to a new format. I would like to reference another Excel workbook while running the command. The only way I have been able to reference that data is by activating the other Excel workbook which I don't really want to do.....basically I would like only to have the initial workbook open and then read the data from the source workbook.
'Now lets Open the Source file to begin checking it is in the correct format
Workbooks.Open(strSourceFullFileName).Activate
Set mySourceRange = Worksheets("Sheet1").Range("A1")
MsgBox "Have found this value at A1" & mySourceRange.Offset(0, 0).Value
Is there anyway to reference that source workbook without activating it ?
I am running a command to convert some data in an Excel workbook to a new format. I would like to reference another Excel workbook while running the command. The only way I have been able to reference that data is by activating the other Excel workbook which I don't really want to do.....basically I would like only to have the initial workbook open and then read the data from the source workbook.
'Now lets Open the Source file to begin checking it is in the correct format
Workbooks.Open(strSourceFullFileName).Activate
Set mySourceRange = Worksheets("Sheet1").Range("A1")
MsgBox "Have found this value at A1" & mySourceRange.Offset(0, 0).Value
Is there anyway to reference that source workbook without activating it ?