Excel 2002 Delete Thisworkbook code Not Working.

**realniceguy5000** · 09-20-2011, 07:43 AM

Good Morning,

I have a small problem where I am using this code below in excel 2003 and it works fine. However when I try to run on a machine with excel 2002 it crashes.

When I looked in the References in VBA,It looks like that maybe something in the 11.0 object library may differ from the 10.0 Object Library, but I'm not sure ???

Is there a work around for the 2002 Machine?

Please Login or Register  to view this content.

Thank You, Mike

**snb** · 09-20-2011, 07:53 AM

You could try (I'd prefer):

Please Login or Register  to view this content.

**romperstomper** · 09-20-2011, 07:57 AM

Do you have trusted access to the vbProject set on the 2002 machine?

**realniceguy5000** · 09-20-2011, 08:03 AM

Thanks SNB... for the try...But the program still crashes at that point in the code. Note this code still works in excel 2003, It only crashes in excel 2002.

Any Other Ideas?

Yes, I have the trust checked on the 2002 Machine.

Thank You, Mike

**romperstomper** · 09-20-2011, 08:16 AM

Is the code running in the same workbook or a different one?

**realniceguy5000** · 09-20-2011, 08:26 AM

It is the same workbook.

The workbook was created on a 2003 Machine, I moved the entire workbook to another 2003 Machine and it works fine. I'm only having issues on the 2002 Machine.

I just ran a test I created a new workbook on the 2002 Machine placed the code in a mod and it ran fine, Whats going on with the other workbook?

Thanks for looking. Mike

**romperstomper** · 09-20-2011, 08:32 AM

Hard to say. Personally I have always avoided code that alters code if at all possible because when it doesn't work, it's a nightmare to correct. It may be that it has improved in later versions but my experiences with 2000-2003 put me off somewhat. I would certainly not try and alter the same project that the code was in.

**realniceguy5000** · 09-20-2011, 08:49 AM

Thank You, maybe I can create this workbook on the 2002 Machine and see how that works.

or

I really need either to delete this code or not run the workbook open code. Maybe I can run a check on the workbook open against the file name. So if the file name = the orginal workbook name it runs and if not it wont.

Let me try that.

Thanks as always for the help.

Mike.