Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 28th, 2004, 06:08 AM
Registered User
Join Date: Sep 2004
Location: London, London, United Kingdom.
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

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

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

All times are GMT -4. The time now is 03:11 PM.

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