Thanks for your response. You mean enter
='C:\Directory\[excelfile.xls]Sheet1'!A1 as a cell formula? I am sorry but I
think I was unclear about my problem. I am looking for a way to copy a range
from an un-opened Workbook A into an opened workbook B using VBA. Can this
be done?

Thanks again for your consideration.

"Crowbar via OfficeKB.com" wrote:

='C:\Directory\[excelfile.xls]Sheet1'!A1

This formula will get the data for you (you will have to change the directory
and file name of course). This formula only retrieves data not formulas

HTH

Regards



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1