Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls in Office 2007 and Office 2000
I have both Office 2007 and Office 2000 dual installed on my computer until
I can be as proficient in 2007 as I am in 2000/2003. Currently I am hopping between the two Excel versions. My problem arose when I was testing some macro code I wrote for Excel 2000 in Excel 2007. It worked fine in 2007 with a few tweaks, but now I can not open that file in Excel 2000. Any thoughts on how to get all my macro code back without attempting to copy and paste each one by hand? Is there a reason that both Excel's are sharing the same file? MS has changed Excel in so many ways in 2007 that I am surprised it is still sharing the personal.xls file and not making it a different extension like they have with the other Excel files. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls in Office 2007 and Office 2000
I don't use xl2007 very much, but did you save that personal.xls as an xl2007
file or did you save it as the older version? Jessica wrote: I have both Office 2007 and Office 2000 dual installed on my computer until I can be as proficient in 2007 as I am in 2000/2003. Currently I am hopping between the two Excel versions. My problem arose when I was testing some macro code I wrote for Excel 2000 in Excel 2007. It worked fine in 2007 with a few tweaks, but now I can not open that file in Excel 2000. Any thoughts on how to get all my macro code back without attempting to copy and paste each one by hand? Is there a reason that both Excel's are sharing the same file? MS has changed Excel in so many ways in 2007 that I am surprised it is still sharing the personal.xls file and not making it a different extension like they have with the other Excel files. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls in Office 2007 and Office 2000
I have 2007 defaulted to save to the older version of excel, and the file has
the xls extension, so it should have saved it so that it was compatible to both, unfortunately it won't open in 2000. "Dave Peterson" wrote: I don't use xl2007 very much, but did you save that personal.xls as an xl2007 file or did you save it as the older version? Jessica wrote: I have both Office 2007 and Office 2000 dual installed on my computer until I can be as proficient in 2007 as I am in 2000/2003. Currently I am hopping between the two Excel versions. My problem arose when I was testing some macro code I wrote for Excel 2000 in Excel 2007. It worked fine in 2007 with a few tweaks, but now I can not open that file in Excel 2000. Any thoughts on how to get all my macro code back without attempting to copy and paste each one by hand? Is there a reason that both Excel's are sharing the same file? MS has changed Excel in so many ways in 2007 that I am surprised it is still sharing the personal.xls file and not making it a different extension like they have with the other Excel files. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls in Office 2007 and Office 2000
If you open the file in Excel 2007 and do a Save As, the current type of
file will appear in the Save As dialog. If it says "Excel 97-2003 Workbook" is 'should' open in Excel 2000. -- Jim "Jessica" wrote in message ... |I have 2007 defaulted to save to the older version of excel, and the file has | the xls extension, so it should have saved it so that it was compatible to | both, unfortunately it won't open in 2000. | | "Dave Peterson" wrote: | | I don't use xl2007 very much, but did you save that personal.xls as an xl2007 | file or did you save it as the older version? | | | | Jessica wrote: | | I have both Office 2007 and Office 2000 dual installed on my computer until | I can be as proficient in 2007 as I am in 2000/2003. Currently I am hopping | between the two Excel versions. My problem arose when I was testing some | macro code I wrote for Excel 2000 in Excel 2007. It worked fine in 2007 with | a few tweaks, but now I can not open that file in Excel 2000. Any thoughts | on how to get all my macro code back without attempting to copy and paste | each one by hand? Is there a reason that both Excel's are sharing the same | file? MS has changed Excel in so many ways in 2007 that I am surprised it is | still sharing the personal.xls file and not making it a different extension | like they have with the other Excel files. | | -- | | Dave Peterson | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls in Office 2007 and Office 2000
When I am in the Visual Basic Code window, there is no save as option; my
only option is to save the module in the Personal.xls file. When I try to open Excel 2000, it tells me that the personal.xls file is in an unrecognizable format. If I switch to the Excel window to save, it wants to save the blank sheet as a new workbook, which is not what I am trying to do. All I need is for the modules I've written to work in both 2007 and 2000, which requires each to read the personal.xls file when they open. "Jim Rech" wrote: If you open the file in Excel 2007 and do a Save As, the current type of file will appear in the Save As dialog. If it says "Excel 97-2003 Workbook" is 'should' open in Excel 2000. -- Jim "Jessica" wrote in message ... |I have 2007 defaulted to save to the older version of excel, and the file has | the xls extension, so it should have saved it so that it was compatible to | both, unfortunately it won't open in 2000. | | "Dave Peterson" wrote: | | I don't use xl2007 very much, but did you save that personal.xls as an xl2007 | file or did you save it as the older version? | | | | Jessica wrote: | | I have both Office 2007 and Office 2000 dual installed on my computer until | I can be as proficient in 2007 as I am in 2000/2003. Currently I am hopping | between the two Excel versions. My problem arose when I was testing some | macro code I wrote for Excel 2000 in Excel 2007. It worked fine in 2007 with | a few tweaks, but now I can not open that file in Excel 2000. Any thoughts | on how to get all my macro code back without attempting to copy and paste | each one by hand? Is there a reason that both Excel's are sharing the same | file? MS has changed Excel in so many ways in 2007 that I am surprised it is | still sharing the personal.xls file and not making it a different extension | like they have with the other Excel files. | | -- | | Dave Peterson | |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls in Office 2007 and Office 2000
Go to Excel. Unhide Personal (Unhide on View tab). Then check the Save As
as I suggested. If it's Excel 2007 format (regardless of the extension) save it in Excel 97-2003 format. Then Hide Personal and go to the VBE and save it again so it's hidden. -- Jim "Jessica" wrote in message ... | When I am in the Visual Basic Code window, there is no save as option; my | only option is to save the module in the Personal.xls file. When I try to | open Excel 2000, it tells me that the personal.xls file is in an | unrecognizable format. If I switch to the Excel window to save, it wants to | save the blank sheet as a new workbook, which is not what I am trying to do. | All I need is for the modules I've written to work in both 2007 and 2000, | which requires each to read the personal.xls file when they open. | | "Jim Rech" wrote: | | If you open the file in Excel 2007 and do a Save As, the current type of | file will appear in the Save As dialog. If it says "Excel 97-2003 Workbook" | is 'should' open in Excel 2000. | | -- | Jim | "Jessica" wrote in message | ... | |I have 2007 defaulted to save to the older version of excel, and the file | has | | the xls extension, so it should have saved it so that it was compatible to | | both, unfortunately it won't open in 2000. | | | | "Dave Peterson" wrote: | | | | I don't use xl2007 very much, but did you save that personal.xls as an | xl2007 | | file or did you save it as the older version? | | | | | | | | Jessica wrote: | | | | I have both Office 2007 and Office 2000 dual installed on my computer | until | | I can be as proficient in 2007 as I am in 2000/2003. Currently I am | hopping | | between the two Excel versions. My problem arose when I was testing | some | | macro code I wrote for Excel 2000 in Excel 2007. It worked fine in | 2007 with | | a few tweaks, but now I can not open that file in Excel 2000. Any | thoughts | | on how to get all my macro code back without attempting to copy and | paste | | each one by hand? Is there a reason that both Excel's are sharing the | same | | file? MS has changed Excel in so many ways in 2007 that I am | surprised it is | | still sharing the personal.xls file and not making it a different | extension | | like they have with the other Excel files. | | | | -- | | | | Dave Peterson | | | | | |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls in Office 2007 and Office 2000
That worked, thank you so much, I was not envisioning pleasant thoughts at
having to redo all the code I wrote and now I won't have to. "Jim Rech" wrote: Go to Excel. Unhide Personal (Unhide on View tab). Then check the Save As as I suggested. If it's Excel 2007 format (regardless of the extension) save it in Excel 97-2003 format. Then Hide Personal and go to the VBE and save it again so it's hidden. -- Jim "Jessica" wrote in message ... | When I am in the Visual Basic Code window, there is no save as option; my | only option is to save the module in the Personal.xls file. When I try to | open Excel 2000, it tells me that the personal.xls file is in an | unrecognizable format. If I switch to the Excel window to save, it wants to | save the blank sheet as a new workbook, which is not what I am trying to do. | All I need is for the modules I've written to work in both 2007 and 2000, | which requires each to read the personal.xls file when they open. | | "Jim Rech" wrote: | | If you open the file in Excel 2007 and do a Save As, the current type of | file will appear in the Save As dialog. If it says "Excel 97-2003 Workbook" | is 'should' open in Excel 2000. | | -- | Jim | "Jessica" wrote in message | ... | |I have 2007 defaulted to save to the older version of excel, and the file | has | | the xls extension, so it should have saved it so that it was compatible to | | both, unfortunately it won't open in 2000. | | | | "Dave Peterson" wrote: | | | | I don't use xl2007 very much, but did you save that personal.xls as an | xl2007 | | file or did you save it as the older version? | | | | | | | | Jessica wrote: | | | | I have both Office 2007 and Office 2000 dual installed on my computer | until | | I can be as proficient in 2007 as I am in 2000/2003. Currently I am | hopping | | between the two Excel versions. My problem arose when I was testing | some | | macro code I wrote for Excel 2000 in Excel 2007. It worked fine in | 2007 with | | a few tweaks, but now I can not open that file in Excel 2000. Any | thoughts | | on how to get all my macro code back without attempting to copy and | paste | | each one by hand? Is there a reason that both Excel's are sharing the | same | | file? MS has changed Excel in so many ways in 2007 that I am | surprised it is | | still sharing the personal.xls file and not making it a different | extension | | like they have with the other Excel files. | | | | -- | | | | Dave Peterson | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
free pre-installed Office interfers with Office 2000 professional. | Excel Discussion (Misc queries) | |||
Email Upgraded from Office 2000 to Office 2007 | Excel Programming | |||
Simple way to enable just my personal macros in Excel (& Office) 2007 | New Users to Excel | |||
Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
comile error for sheet in office 2000 but not office 2003?? | Excel Programming |