(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:
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
Thanks!! ~AS
Bookmarks