Hi Guys

I recently published a post about a problem I have with a number o
applications which I originally developed under NT/Excel97 and hav
migrated to XP/XL2002.
The spreadsheet applications were completely standalone - no externa
links, but made a lot of use of embedded combo boxes. The application
are robust and sound in the NT/97 world and also run totally robustly o
Win2K/XL2000. The problem is on some, but not all of our XP/XL200
boxes.

Since I migrated the applications we have never been able to get the
stable - across our organisation we have some 4000 PCs, ostensibly al
identical builds. The applications does not crash on all of the PC
but consistently crashes on some PCs, and intermittently crashes o
other PCs. The crashes are consistent - ie the point of crash and th
types of crash: essentially the applications stops working with a
irrecoverable error: quite often on opening there is a runtime error
"cannot create object cmbCountry", "object not found" - refering to on
of the combo's. "object does not exist" refering to a worksheet page,
piece of code runs and the application is returned to the user'
control with half of the screen coloured grey (like the project men
side in the vba editor/or the tree view side in Outlook).

One way I can guarantee to make the application crash is if I compil
the code before saving the application. When I compile the code an
save, the file size is some 25% bigger than if I just simply save th
file.

I am 99.99% certain that I am not using any reserved words within m
code, everything is fully declared and I have looked at every obviou
thing I can. This is a major, major problem which has slowly driven m
demented. We have been trying to fix this for well over three month
now.

The one thing I can point to is this problem appears to start when th
code is compiled. [When a spreadsheet opens the code is compile
anyhow - so what is the difference?]. If the spreadsheet opens an
runs, shortly after opening it is saved (via code) to a user director
with a completely new name - the size of the file does not increment
in the same was as if the vba code was compiled prior to saving.

Has anyone please got any clues as to what could be going on - or wher
I look next - or what tools might be available to thoroughly tear m
code/spreadsheet apart and look for the offending item?

Thanks in anticipation of any contributions - and thank you to those o
you who answered my original post.

Regards

Mike Tyre

--
mike_tyre
-----------------------------------------------------------------------
mike_tyrer's Profile: http://www.excelforum.com/member.php...fo&userid=1466
View this thread: http://www.excelforum.com/showthread.php?threadid=26414