| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
| Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
| Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
| Macros in Excel | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Hybrid Mode
