Wrox Programmer Forums
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 28th, 2004, 06:08 AM
Registered User
Join Date: Sep 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default XL2002/ XP

Hi Guys

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

Since I migrated the applications we have never been able to get them stable - across our organisation we have some 4000 PCs, ostensibly all identical builds. The applications does not crash on all of the PCs but consistently crashes on some PCs, and intermittently crashes on other PCs. The crashes are consistent - ie the point of crash and the types of crash: essentially the applications stops working with an irrecoverable error: quite often on opening there is a runtime error, "cannot create object cmbCountry", "object not found" - refering to one of the combo's. "object does not exist" refering to a worksheet page, a piece of code runs and the application is returned to the user's control with half of the screen coloured grey (like the project menu 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 compile the code before saving the application. When I compile the code and save, the file size is some 25% bigger than if I just simply save the file.

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

The one thing I can point to is this problem appears to start when the code is compiled. [When a spreadsheet opens the code is compiled anyhow - so what is the difference?]. If the spreadsheet opens and runs, shortly after opening it is saved (via code) to a user directory 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 where I look next - or what tools might be available to thoroughly tear my code/spreadsheet apart and look for the offending item?

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


Mike Tyrer

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spaces XP Programmer911 General .NET 1 December 19th, 2007 07:03 AM
iis in xp simo BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 0 January 15th, 2005 10:17 AM
Windows XP btls Wrox Book Feedback 1 July 13th, 2004 02:41 PM
IIS in XP and 2000 mikko Classic ASP Databases 1 April 13th, 2004 11:05 AM
ASP3.0 with XP version shezawi ASP.NET 1.0 and 1.1 Basics 5 October 30th, 2003 12:01 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.