Macros in Excel
 

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?
--
B

Macros in Excel
 

If I understand you correctly, simply open the file in 2007 and save it as a
2007 file. HTH Otto
"Beverly" wrote in message
...
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?
--
B

Macros in Excel
 

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.

Beverly wrote:

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?
--
B

--

Dave Peterson

Macros in Excel
 

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


"Beverly" wrote:

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?
--
B

Macros in Excel
 

Duke Carey wrote:
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


"Beverly" wrote:

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?
--
B
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