I am mainly working on a migration project to migrate Excel 2003 to Excel 2010.

One of the common problem I have is the error message: unable to compile a hidden module.

To understand the underlying cause of the issue, I want to know what version of VBA is in Excel 2003 and what changes have been introduced to it in Excel 2010.

There is a similar question in SO but did not cover Excel 2003


To determine the type of VBA your Excel 2003 has go into the editor, select Help -> About Microsoft Visual Basic...

On my machine it's listing Excel 2003 with VBA 6.5. The changes are explained here. They primary difference I see is that any (x86) API calls may need to be formed differently.

In my experience migrating to Excel 2010, I have had no compatibility issues of bringing old code forward. All of the problems have been from missing references.

Make sure to unlock your VBA and see if there are any missing references on your test machine. Hopefully, that's your only problem.

Good luck.

  • +1 for "All of the problems have been from missing references." – Chad Harrison Aug 27 '12 at 15:40
  • @hydroparadise I wish my problem is this simple. – Anthony Kong Aug 28 '12 at 0:08

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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