Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have two workbooks
I have two workbooks, for instance book1 (currently active) and book2, I
want press combination of Ctrl, Shift and C when book1 is active to open book2, after that select some data from book2 and press combination of Ctrl, Shift and t to transfer data selected from book2 to book1. Please tell me the way using VBA to make the task. I already conducted but failed -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have two workbooks
Ok, you are in 'book1', first open 'book2':
workbooks.open("[path]\Book2.xls") Now activate Book2 windows("Book2.xls").activate 'select the data you want to copy windows("Book1.xls").activate 'now put the data into book1 workbooks.close("Book2.xls") "anh82tb via OfficeKB.com" <u11343@uwe wrote in message news:64437f235655f@uwe... I have two workbooks, for instance book1 (currently active) and book2, I want press combination of Ctrl, Shift and C when book1 is active to open book2, after that select some data from book2 and press combination of Ctrl, Shift and t to transfer data selected from book2 to book1. Please tell me the way using VBA to make the task. I already conducted but failed -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regular Workbooks vs. Binary Workbooks | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) |