Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am about to roll out Office 2007 to 1600 users. Most of it seems straight forward, but this client is particularly worried about macros and VB scripts not working. How do you migrate them in the first place? Does anyone have a good strategy on how to handle macros/VB scripts, which may currently be in use with Office 2003?

I am also hoping they will just work, but we may bring in a scripting expert just in case they need editing. If you know anything about lack of compatibility, I am also all ears.

Thank you.

share|improve this question
you are just now going to 2007? Support for 2007 ends just shy of a year? – Jim B May 25 '11 at 14:27
You should also TEST the deployment before rolling out it to all 1600 users... Test the files with vb and macros... – xeon May 25 '11 at 15:21
Jim B, Not my call...just a subcontractor. Xeon, we definitely plan on testing. – KCotreau May 25 '11 at 16:43
up vote 1 down vote accepted

Most of it will not need migration. But as Office 2007 has different default security settings in regard to macros and VB code, some setting changes (presumably via GPO) would be needed to make things "work as before". There is a short publicly available writeup published on Directions on Microsoft several years ago - it should help you determine the things to consider.

share|improve this answer
I called Microsoft today, and what you said is basically true. Since the macros are actually contained in each file, there is nothing to migrate. I do have to be careful that the security settings are not elevated, and that there are no 3rd party add-ons, which may be written to only use Office 2003. – KCotreau May 26 '11 at 22:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.