How import data from a closed file with an update button

[efmelp]

Hello,
I was wondering if someone can help me and creat a script for me that can import data from a closed file without openning the closed file and I would like if there is a button to click on if i want to update from the closed file.
I attached two files as an example of what is required.
Thanks in advance

[VBA Noob]

This link should get you started.

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

VBA Noob

[efmelp]

Thanks a Lot