cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
vanig
Visitor
Visitor
8,525 Views
Registered: ‎12-06-2012

PROBLEM OPENING XMP277- 7 SERIES SCHEMATIC REVIEW RECCOMENDATIONS

Hi,

 

I am having problem while opening 7_Series_Schematic_Review_Recommendations.xls.When clicking on 'CREATE NEW CHCKLIST'  "compile error in hidden module:module4" dialog box is being displayed.Please help.

0 Kudos
6 Replies
gszakacs
Instructor
Instructor
8,516 Views
Registered: ‎08-14-2007

I have the same problem with Excel 2003 and OpenOffice 4.  It's likely that this spreadsheet uses some functions introduced more recently by Microsoft.  This is one of the reasons I detest Microsoft Office.  It is incompatible with itself as well as with the rest of the world.

-- Gabor
0 Kudos
pontuss
Visitor
Visitor
8,483 Views
Registered: ‎10-11-2013

I found this on Stack Overflow:

 

"

This is due some problem with references within VBA in your workbook.

In the VBA editor, go to 'Tools-> References'. There you would find a reference with 'MISSING:' in front. Uncheck that and your problem should be fixed.

If the missing reference was something like 'Visual Basic for Application' or 'Microsoft Office Object library, you should look for a reference that has no 'MISSING:' text and select this.

"

 

You find this in Tools>Macros>Visual Basic Editor

this opens a VBA editor, click on VBAProject(7_series ...), password: austin

Now do Tools>References and follow the advice above from stack overflow.

 

Apperantly the "Mid" funcrion was not found?!?

 

Now it works for me!

 

-- Pontus

 

gszakacs
Instructor
Instructor
8,480 Views
Registered: ‎08-14-2007

That did the trick!  How did you get the password? Was that on Stack Overflow, too?

-- Gabor
0 Kudos
pontuss
Visitor
Visitor
8,469 Views
Registered: ‎10-11-2013

No,

while debugging the problem I opened it in openoffice and could read the code in clear text,

it used "austin" to unprotect sheets etc. IIRC.

 

gszakacs
Instructor
Instructor
8,464 Views
Registered: ‎08-14-2007

In that case Kudos to OpenOffice as well!  I guess this just shows how "secure" MS-Office protection is...

-- Gabor
0 Kudos
rikraf
Explorer
Explorer
4,424 Views
Registered: ‎01-15-2008

Double kudos from me, thanks.  I added a resistor to PUDC as a result of going through that checklist, probably saving me a month of head-scratching.  Couldn't have done it without the password!

 

Rick

0 Kudos