Referencing other workbooks

B

Bob Kilmer

Do the Copy on one line, then then PasteSpecial.


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

should work.
 
S

Stuart

Is it pooable to paste something into another open workbook without
activating it?

such as :-

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

instead of :-

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

Bob Kilmer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Object variable or with Block variable not set 9
Cell values to an array, then array transpose to another workbook 8
Having difficulty copying and pasting on VBA 3
Formatting and copy or copy and formatting ?? 2
CUT not COPY but errors 8
Convert A1 value to a sheet name and copy to it 2
Select Case Code does not run... 10
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Top