Super User is a question and answer site for computer enthusiasts and power users. 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 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

share|improve this question
up vote 2 down vote accepted

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.

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .