Macros in Excel

[Beverly]

I have a large spreadsheet created in Excel 2003 that I want to bring over to
Excel 2007 that was created by someone else. I want to bring that file over
to Excel 2007 keeping all of the macros. How do I do that?

 

[Otto Moehrbach]

If I understand you correctly, simply open the file in 2007 and save it as a
2007 file. HTH Otto

 

[Dave Peterson]

Open the file in xl2007.

If it's important to you, you can save the workbook (as a new name???) as an
xl2007 workbook.

There's a very good chance that you won't have to do anything special.

 

[Duke Carey]

2007 allows you to save workbooks in (at least) 3 new formats:
..xlsx (no macros allowed)
..xlsm (macros allowed)
..xlsb (macros allowed, I think)

Open the file in 2007 and choose to save it either as an .xlsm or an .xlsb

 

[Bill Sharpe]

2007 allows you to save workbooks in (at least) 3 new formats:
.xlsx (no macros allowed)
.xlsm (macros allowed)
.xlsb (macros allowed, I think)

Open the file in 2007 and choose to save it either as an .xlsm or an .xlsb

If you don't need the new features of Excel 2007, you can still save the
workbook with an .xls extension. That should keep your macros working.

Bill