Cell references in other workbooks

[Jeffrey Zurofsky]

In using two different versions of excel on a network,
some references to another workbook will return an error
unless the other workbook is actually open. Any thoughts
on this?

thanks.

 

[Kenji]

Hi Jeffrey,
If you are doing this with macros, yes it's possible for sure.

Just open the other excel sheet by declaring it as an object in VBA.

For example

Dim oExcel As New Excel.Application
oExcel.Workbooks.Open ({location of excel sheet})

and then you can access the data on that excel sheet with something like
msgbox oExcel.ActiveWorkbook.Sheets("Sheet1").Cells(1, 1).Value

Good luck!

Kenjiro Yagi