Compile Error in Hidden Module: Main Module

[Joffa]

I'm trying to edit an Excel 95 macro in 2000 and it seems to have now
locked a module with a complile error in hidden module: main module,
which I'm presuming is because it doesn't like some of the old code in
one of the modules that no longer exists in 2000. Does anyone know any
way of unlocking/fixing this issue as I need this .xla file urgently
and cannot recreate it without being able to view the code used?

 

[Jezebel]

'hidden module' usually means just that the file containing the code isn't
open. Open the .xla file explicitly, then try your macro again.

 

[Tony Jollans]

This is a Word newsgroup; you would be better posting Excel questions to an
Excel newsgroup. However I don't think an Excel 95 workbook/addin could give
this error as it didn't have VBA.

 

[Perry]

First of all, this is a Word Newsgroup.

Next
Having done multiple Office migration projects for various
companies, what I can advice:

Office 95 to Office 2K requires an intermediaire step, namely
Office 97 when it comes to Excel VBA issues.
Reason:
There are some (VBA translation DLL's) missing in Office 2K
that are still available in Office 97.
Excel 95 VBA offered the possibility to program in other languages besides
English.

Chances are that yr Excel 95 xla contained some code in the other lingo
causing the runtime error y're reporting.
The intermediaire conversion to Excel 97 can remedy.

Krgrds,
Perry

 

[Perry]

Other advice:
Excel 95 code compile seamlessly and beautifully in all other
Excel 95+ versions, if not you'll have to look at what I stated in previous
msg's

Other problems encountered when trying to migrate Excel 95 code:
- If Project 98 is on the system, de-install Project 98. When Project 98
is de-installed, test yr migrated Excel 95 xla.
Reason:
Project 98, redirects a VBE DLL...

Other known issues when migrating are the usual suspects, such as:
- Profile settings have changed
- Installation directories have changed
- Startup directories have changed
- Privileges have changed
- Other network settings have changed

Krgrds,
Perry

 

[Peter Jamieson]

However I don't think an Excel 95 workbook/addin could give this error as

it didn't have VBA.

FWIW VBA is there in Excel 95 ("Visual Basic" is in Excel 5, but I don't
think it was transformed into "VBA" until 95). /Word/ 95 only has WordBasic
and Word VBA only arrives in Word 97.

These old versions run so much better these days than they did at the time


Peter Jamieson

 

[Joffa]

Many thanks and sorry for the confusion RE Excel - will try your
suggestion.

 

[Perry]

Apart from the usual suspects written in my last contribution
one important is missing:
- Missing VBE libraries
I've copied the other reported usual suspects for yr convenience below.
Don't forget the pointers on:
- Excel 97 conversion
- Project 98 de-installation

Krgrds & Good luck!!
Perry

Other known issues when migrating are the usual suspects, such as:
- Profile settings have changed
- Installation directories have changed
- Startup directories have changed
- Privileges have changed
- Other network settings have changed