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

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

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