Thread: Copy Values From A Non-Open Workbook?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Crowbar via OfficeKB.com Crowbar via OfficeKB.com is offline
external usenet poster
  
Posts: 128
Default Copy Values From A Non-Open Workbook?
='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
Reply With QuoteReply With Quote