Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.