Referencing other workbooks
Do the Copy on one line, then then PasteSpecial.
Windows("TEMP.XLS").Sheets("Sheet1").Range"B3").Co py Windows("ORIG.XLS").Sheets("Sheet1").Range"B3").Pa steSpecial (xlPasteAll) should work. -- Bob Kilmer "Stuart" wrote in message ... 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 |
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 |
Referencing other workbooks
or if not that, this will copy from specified range from TEMP.XLS to
specified range of ORIG.XLS Workbooks("TEMP.XLS").Worksheets("Sheet1").Range(" A1").Copy Workbooks("ORIG.XLS").Worksheets("Sheet1").Range(" A1").PasteSpecial Paste:=xlPasteAll "Bob Kilmer" wrote in message ... Do the Copy on one line, then then PasteSpecial. Windows("TEMP.XLS").Sheets("Sheet1").Range"B3").Co py Windows("ORIG.XLS").Sheets("Sheet1").Range"B3").Pa steSpecial (xlPasteAll) should work. -- Bob Kilmer "Stuart" wrote in message ... 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 |
All times are GMT +1. The time now is 11:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com