Using offline XLS files in a Master WB

Hello Felipe,

Welcome to the Forum!

To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a new member please read the Do's and Don'ts here in the Forum. Click on the link below...

Forum Rules

Sincerely,
Leith Ross

Sorry about the newbie mistake, won't happen again.

Hello Felipe,

Here is a site that may be of interest to you. It deals with retrieving data from closed workbooks. Look in section titled Copy/Paste/Merge examples.

http://www.rondebruin.nl/tips.htm

Sincerely,
Leith Ross

Leith:

You are a genius! The link you gave me fits perfectly my needs. Thank you very, very much.