Link to home
Create AccountLog in
Avatar of AXISHK
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.
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Not all of them no. Most will work just fine but if you use Application.Filesearch  in your macros that will not work in Office 2007. You may also have a few minor issues with charts but they are usually fairly easy to resolve.
Regards,
Rory
Avatar of AXISHK
AXISHK

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 ?
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.
Avatar of AXISHK

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  ?
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer