Thread: Referencing other workbooks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_9_] Stuart[_9_] is offline
external usenet poster
  
Posts: 5
Default Referencing other workbooks
Is it pooable to paste something into another open workbook without
activating it?

such as :-

Windows("TEMP.XLS").Sheets("Sheet1").Range("B3").P asteSpecial (xlPasteAll)

instead of :-

Windows("TEMP.XLS").Activate
Sheets("Sheet1").Range("B3").PasteSpecial (xlPasteAll)
Windows("ORIG.XLS").Activate



Reply With QuoteReply With Quote