#1   Report Post  
Posted to microsoft.public.excel.misc
H.
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repost:Automatically inserting a row in external workbook 50pingviner Excel Discussion (Misc queries) 3 December 28th 05 07:38 PM
keeping a toolbar attached to a workbook Paul Ponzelli Excel Discussion (Misc queries) 0 August 12th 05 11:39 PM
Find a value in a workbook and return the worksheet name Craig Excel Discussion (Misc queries) 2 August 10th 05 09:47 PM
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM
How to hyperlink from a workbook to sheets in another workbook? MJOHNSON Excel Worksheet Functions 0 February 17th 05 08:31 PM


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"