1

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

1 Answer 1

2

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.

2
  • +1 for "All of the problems have been from missing references." Aug 27, 2012 at 15:40
  • @hydroparadise I wish my problem is this simple. Aug 28, 2012 at 0:08

You must log in to answer this question.

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