ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Compilation error in Excel 97 (https://www.excelbanter.com/excel-programming/333823-compilation-error-excel-97-a.html)

vinayrbedre

Compilation error in Excel 97
 

Hi all,
when i open my file.xla in excel 97 in system 1, i get an error calle
"compilation error in hidden module",
but i wont get the same error in excel 97 system 2. The same progra
works in excel 2000, excel 2002,excel xp,excel 2003 correctly.

I am not able to figureout the problem ,. could you please help meou
in finding the solution for this,.
Thanks & Best Regards,
Vina

--
vinayrbedrePosted from http://www.pcreview.co.uk/ newsgroup acces


Bob Phillips[_7_]

Compilation error in Excel 97
 
Not unless you can unprotect the code and tell us what the error is.

You may some add-in or workbook that is VBA protected that is throwing this
up.Do you know if there are any such books?

--
HTH

Bob Phillips

"vinayrbedre" <vinayrbedre.1rse1z@ wrote in message
...

Hi all,
when i open my file.xla in excel 97 in system 1, i get an error called
"compilation error in hidden module",
but i wont get the same error in excel 97 system 2. The same program
works in excel 2000, excel 2002,excel xp,excel 2003 correctly.

I am not able to figureout the problem ,. could you please help meout
in finding the solution for this,.
Thanks & Best Regards,
Vinay


--
vinayrbedrePosted from http://www.pcreview.co.uk/ newsgroup access




DM Unseen

Compilation error in Excel 97
 
Vinay,

I suspect a reference issue, pls open the xla in VBA and look into
tools-references for MISSING references.

Dm Unseen



All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com