If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Office 97 to Office XP-Macros
Hello:
Will Excel 97 macros convert cleanly into Excel 2002? If not, what should be done to ensure that the macros work in Excel 2002? What errors should I expect? Thanks Dean |
#2
|
|||
|
|||
Office 97 to Office XP-Macros
Dean,
Generally speaking, VBA code written in Excel97 will work perfectly well under later versions of Excel. No modification is necessary. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dean" wrote in message ... Hello: Will Excel 97 macros convert cleanly into Excel 2002? If not, what should be done to ensure that the macros work in Excel 2002? What errors should I expect? Thanks Dean |
#3
|
|||
|
|||
Office 97 to Office XP-Macros
I was interested in this answer because I will soon be
using a new computer with Excel XP. When you change computers, but want to save your macros, which file(s) do you need to copy? --Jan -----Original Message----- Dean, Generally speaking, VBA code written in Excel97 will work perfectly well under later versions of Excel. No modification is necessary. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dean" wrote in message ... Hello: Will Excel 97 macros convert cleanly into Excel 2002? If not, what should be done to ensure that the macros work in Excel 2002? What errors should I expect? Thanks Dean . |
#4
|
|||
|
|||
Office 97 to Office XP-Macros
Macros live in workbooks.
So you'll have to save all your workbooks that have macros. (I'd guess that you'd want to save all your workbooks--with or without macros!) But I'm guessing that you'll want to go out of your way to find your macros in XLStart (usually named personal.xl*). I have a short list of things to copy/update when we do this at work. It's far from complete, but it gets most of the stuff. Word/Excel files: FileName Use custom.dic personal dictionary *.acl personal autocorrect list mssp2_en.exc personal exclusion dictionary normal.dot default (for new documents) template *.dot Any other templates you've made *.xlb personal toolbar (*see the note below) book.xlt defaults for new workbooks sheet.xlt defaults for new worksheets personal.xl* personal macros *.xlt Any other templates you've made And don't forget any: Local files (If you don’t store on LAN) (Settings) Directories and other defaults ==== And if you're staying within the same version of xl (xl2002 for both pc's), I'd copy over my *.xlb, too. (If you're upgrading, don't do this. Build your new one from scratch and you'll see lots of new icons that have been made available!) And before you actually paste that *.xlb file, take a look at the filesize of your current *.xlb file. I'd dump it if it's too large (20k is usually already pretty large). "J. Kunkel" wrote: I was interested in this answer because I will soon be using a new computer with Excel XP. When you change computers, but want to save your macros, which file(s) do you need to copy? --Jan -----Original Message----- Dean, Generally speaking, VBA code written in Excel97 will work perfectly well under later versions of Excel. No modification is necessary. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dean" wrote in message ... Hello: Will Excel 97 macros convert cleanly into Excel 2002? If not, what should be done to ensure that the macros work in Excel 2002? What errors should I expect? Thanks Dean . -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|