Code to Read/Copy Data from Closed Wb and Return/Paste in Active Wb

(a bit similar to the xWizardx post re: calling date data; ultimately I could not find solution from this thread)

Workbook A contains, among a total of 20-30 named ranges, the named range "MyName".

I would like to, upon command button click (which I'm good with), read this file, copy the data ("MyName" and the others), and return the data to a specified worksheet ("DataDump" - Cell A1 filling down) in my Active Workbook.

I am currently working with / attempting to modify the following:

Please Login or Register  to view this content.

This code does successfully retrieve/paste the "MyName".

1. Is there a way to collect all the data at once, and then paste all the data at once?

2. Is there a way to do this without actually opening the queried file?

3. If not, is there a way to override the 'must save prompt' of the queried workbook after

Please Login or Register  to view this content.

Thanks!! ~AS

Please Login or Register  to view this content.

To avoid getting a save prompt.

The WB must be opened to gain access to the data.

Can't see why you could not simply copy paste and modify the Copied named ranges, and destination ranges in the other WB.