How can I pull data from a specific cell from a closed worksheet in
VBA?

Not sure but I think that
Workbook("wb1.xls").Worksheet("Sheet1").Range("A2" ) only works if the
worksheet is open.

Any help would be appreciated,

Matts


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile: http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=508116