Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help pasting to open external workbook with vba
I need to copy a range of data in an active worksheet(say workbook
A.xls) to a worksheet in an open workbook in another instance of excel 97 (say workbook B.xls). I can programatically accomplish the copy part from A. I can even then manually select a cell in the other open workbook (B) and manualy paste the range, but I have been unable so far to accomplish the paste in vba. I suspect that I need to make B.xls the active workbook and then the paste will work. How do I switch the active workbook to B? Curtis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help pasting to open external workbook with vba
Curtis,
You can try this. Workbooks("B.xls").Range("A3").PasteSpecial Paste:=xlPasteAll HTH Charles --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
inadvertent external links when copy/pasting | Excel Discussion (Misc queries) | |||
Formatting - Pasting fm external app | Excel Discussion (Misc queries) | |||
External data query leaves datasource workbook open | Excel Discussion (Misc queries) | |||
Links only update when external workbook is open | Excel Worksheet Functions |