• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get the value of named ranges from a closed workbooks

T

Trebormac

New Member
Hi All,


I need to iterate through several dozen closed workbooks and capture infor from several named ranges in each workbook and paste that data into another open workbook. I have a procedure and a fuction which orks with formula ranges such as "B2", "F29" "G76" etc., but it will not work with range names such as "To_Days_Sales$", No_Products_Sold", "No_SKS_Sold", etc.


Does anyone have any suggestions?


Thanks,


Trebormac
 
When you say "closed workbooks", are you wanting the macro to loop through and open all of the workbooks one at a time, or are you trying to pull info from a closed workbook w/o opening it?
 
Trebormac


have a look at these 2 posts from Daily Dose of Excel

http://www.dailydoseofexcel.com/archives/2004/12/01/indirect-and-closed-workbooks/

or

http://www.dailydoseofexcel.com/archives/2007/12/23/page-update-copy-a-range-from-closed-workbooks-ado/
 
You must log in or register to reply here.
Back
Top