I'm trying to use the following script to copy a variable named range in an unopened workbook into the active workbook that the code is running in.
I have a couple of problems.
I got a good part of the script from the MS KB article herehttp://support.microsoft.com/kb/257819)

I have two problems with the below code:
  1. I get a "Run time error 424; Object required" error for the line "Set Proj_Conn = CurrentProject.Connection"
  2. while I can reference the named range in the 2nd file, I can't seem to get it to copy the range into the active sheet.
Any ideas would be greately appreciated
Please Login or Register  to view this content.