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.