Import macros from 2003 to 2007

[Ozzie2842]

Our IT department finally upgraded our systems with Office 2007. In Excel 2003 I had several macros built to run some routine functions for me. I created a new workbook in the 2007 version, imported my data, however, the macros are nowhere to be found. Any ideas on where to find them and get them working in 2007?

 

[wigi]

What kind of macros was it? Events? UDF's?
Where were they located: in different files, in the Personal macro workbook, ...

What do you mean with "I created a new workbook in the 2007 version"? Is this just creating a new file like in Ctrl-N? Then you will have an empty file.

 

[Ozzie2842]

The macro was user defined. The macros were assigned to a specific workbook, thus I am guessing they were personal macros. The real question is how to I make them available to new (Ctl-N) workbooks/worksheets? If I can get to the old workbook, is it practicle to copy the code and paste it in a module in a new workbook?

 

[wigi]

Yes, open both workbooks and in the Project Explorer in VBA (Ctrl-R) you can simply drag and drop modules to also have them in the new file.

 

[Ozzie2842]

That's the ticket - thank you!