vba challenge

[pnuckle]

hallo members!
can this be possible?

DATArecording is a closed workbook
it has sheet1 with A1 = count(B:B)

am currently coding in VBE of another workbook and i have
Dim t as integer
Is it possible to directly assign A1(from sheet1 of DATArecording) to t without opening DATArecording?

If it's possible what might be the method used?
Thanx in advance!

 

[dave3009]

In order for something to be assigned it must exist. I'd say opening and closing the workbook is going to be a lot more robust than any other method.

 

[pnuckle]

am using excel 2010 pro plus on windows 7

 

[Ruddles]

If you really want to avoid opening the workbook, you could add a reference to your other worksheet somewhere out of the way on your current worksheet and use that:-

Range("X1")="='C:\Folder\[DATArecording.xls]Sheet1'!A1"
t=Range("X1").Value

Don't assign it directly to an integer type variable though, as it may not be a numeric value.

As Dave says, opening the other workbook is more robust as you can check whether it exists, and check whether the sheet exists, before you try to use the value.