Strange Compile error 
Author Message
 Strange Compile error

We have an excel application (that has about 10000 lines of code). The
application is sent out to about 50 countries world wide. we are having
a problem in two of the sites - Australia and Singapore. The problem is
that when running a routine it gives an error "compile error". The
strange thing is that I had compiled the excel workbook (using debug-
compile and did not get any error). Anyway, after a lot of head banging
we finally could cure the problem by making the user go into the VBA
module and then compile the code locally!
Now I need to send updates to the sites and i figured that if I sent a
spreadsheet without compiling it then it would compile locally and the
problem would be solved. However sending an uncompiled version only
seems to make the problem worse.
Does any one know what is causing this problem? and is there any
command for me to compile the workbook dynamically(locally) after it is
sent to the local site. since otherwise after each update i am forced
to get the user to compile it manually and Australia time zone means
staying up late!!
Thanks,
george

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Closing Excel generates strange compile error

2. Strange Compile error using Access & ODBC SQLServer

3. Strange Compile Errors at Run-time

4. Strange Compile Errors at Run-time

5. strange compiling error

6. Strange Compile Errors at Run-time

7. Strange Compile Errors at Run-time

8. Strange Compile Errors at Run-time

9. Strange false compile error message

10. Compile error: Automation error, Error 32811: Unexpected error


 
Powered by phpBB® Forum Software © phpBB Group