Thread: copy value from unopened workbook
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default copy value from unopened workbook
activecell.formula = "=" & ActiveCell.Value &
"+'C:\myfolder[MyFile.xls]sheet1'!B9"
ActiveCell.Value = ActiveCell.Value

--
Regards,
Tom Ogilvy

"Gary Keramidas" wrote in message
...
is there a way to copy cell values from an unopened workbook and add that
value to an existing value in an opened workbook?

--


Gary





Reply With QuoteReply With Quote