Error In Macro Code

[greenfalcon]

I have this code, i pulled it from a very informative site here http://www.cpearson.com/excel/vbe.htm

here is the section that i am interested in

***********************
Copying Modules Between Projects

There isn't a single method to copy modules from one VBProject to another. Instead, you have to export the module from one project, and then import it into another. The following procedure will copy Module1 from Book2 to Book1.

Please Login or Register  to view this content.

*******************************

when i try to use this code i get a range out of bounds error. Basically it can not find my book1 and book2 files. can anyone help me so i can figure out how to modify this code to have it select where to look for the .xls files?

thanks

[rvExcelNewTip]

Do you have access to VBProjects? By default Microsoft, never trusting anyone, diables this access.

To enable it in Excel: Tools->Macros->Security->Trusted Sources tab: Checkbox on the bottom of that page: Trust Access to VBProjects

[john456852]

also, be sure that you enabled macros

[Palmetto]

greenfalcon,

Please edit your thread to add code tags as required by the forum rules.
You must use the tags when posting VBA code.

Just highlight all of the code and press the # button to add the code tags