Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unopened workbook
There is a workbook on our network that I do NOT want to open, but I still
want to select a certain range in that closed workbook and paste it in my own (open) workbook. Possible? I have all the rights on that unopened workbook. So that is not a problem. H. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unopened workbook
Hi H.
You can use ADO http://www.rondebruin.nl/ado.htm Or this example http://www.rondebruin.nl/copy7.htm -- Regards Ron de Bruin http://www.rondebruin.nl "H." wrote in message ... There is a workbook on our network that I do NOT want to open, but I still want to select a certain range in that closed workbook and paste it in my own (open) workbook. Possible? I have all the rights on that unopened workbook. So that is not a problem. H. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions |