Need a VBA module to open 2 excel files and copy named range data from File1 to File2

[PeterMac65]

Hi excel Gurus,
I wish to open File1.XLSX and also File2.XLST and copy ALL the named ranges from File1.SheetA and paste the value into File2.SheetA.

I think the VBA will in a separate file called MODULES.XLSM

Sounds simple and I have seen some code that I could adapt but hope there might be something floating about that will do the job

Regards Peter

 

[igold]

A couple of questions:
1) Are you going to have all three workbooks open when you run the code (that is the easiest solution to write for)
2) Although you stated that you want the Named Ranges from File1.SheetA, is that truly the case or do you want all the Named Ranged in Workbook File1
3) Where on SheetA in File2 do you want to start the list of the Named Range values

 

[PeterMac65]

Hi igold,

I am going to have all three workbooks open when I run the code.

I propose opening Modules.xlsm
Then ask for the name of "File1"
Then Open "File2" (which is a template file)

I then wish to copy all the named Range values from two (or more) sheets and if there is a matching range name in the template, copy the values from File1 to File2.

I will then Close File1 without saving leaving the File2 file open so i can check it seems OK before saving.

Regards Peter