Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 233
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: Compilation error in Module 1. How can I find it? Tom Torda Excel Discussion (Misc queries) 1 January 13th 07 11:51 PM
After each new dll compilation I have to set the reference to the dll in Excel again. Oscar Excel Programming 3 June 5th 05 10:14 PM
VBA Excel compilation error + Z + Excel Programming 1 January 15th 05 05:54 PM
EXCEL VBA - Data compilation coming in from an external feed marcus[_2_] Excel Programming 0 January 29th 04 04:14 AM
Compilation error question Nathan Gutman Excel Programming 7 December 5th 03 07:54 PM


All times are GMT +1. The time now is 12:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"