AXISHK
asked on
Reuse word 2003 & Excel 2003 macro on Office 2007
Can I reuse all the macro created on Word 2003 and Excel 2003 under Word 2007 and Excel 2007 ?
Many thanks.
Many thanks.
ASKER
Just want to clarify something ..
Can I just open the Word/Excel 2003 Excel under Office 2007, and save it as 2007 format. will the macro will then try to convert for me, or I need to retype all the macro under Office 2007 ?
Can I just open the Word/Excel 2003 Excel under Office 2007, and save it as 2007 format. will the macro will then try to convert for me, or I need to retype all the macro under Office 2007 ?
You need to save the files in a macro-enabled format, but otherwise you do not need to do anything. The code will remain exactly as it was.
ASKER
Is macro code in Word 2007 is stored inside the Word, ie .docx ?
I was told that macro code for Word and Excel for 2007 is stored in another file which is separated from main document (.docx). Is that true ?
From your information, it seems that there is no big change for macro in Word 2003 and 2007 (except some synatx difference between two version) . Am I correct ?
I was told that macro code for Word and Excel for 2007 is stored in another file which is separated from main document (.docx). Is that true ?
From your information, it seems that there is no big change for macro in Word 2003 and 2007 (except some synatx difference between two version) . Am I correct ?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Regards,
Rory