Client's machine crash on VBA in Excel 
Author Message
 Client's machine crash on VBA in Excel

I have a few Excel templates that I use that I have added some VBA backed
buttons to. When others in the company try to open them, they crash and
leave them inthe VB design window with an error message. The message varies,
but the upshot is that their machines do not support the functions that I am
using, whereas mine does. (I have a full suite of developer's apps including
Visual Studio, whereas they have OEM Office 2K or XP). For instance, they
might break on the Environ function with an error of "Unknown library or
object". Question:

What extras do I need to install on their machines to give them full VBA
functionality ?? They already have EVERYTHING checked on their Office
installation from the Small Business OEM CD.

thanks, P



Wed, 20 Jul 2005 00:19:14 GMT  
 Client's machine crash on VBA in Excel
Hi Randy,

Quote:
> using, whereas mine does. (I have a full suite of developer's apps
including
> Visual Studio, whereas they have OEM Office 2K or XP).
and
> functionality ?? They already have EVERYTHING checked on their Office
> installation from the Small Business OEM CD.

Y're making use of several libraries, dll's and ocx files that aren't
registered on the
user's machines, that's clear.

Quote:
> What extras do I need to install on their machines to give them full VBA
> functionality ??

Oops, that's a question we can't answer because we don't know what y're
making use of, and what is missing on the target PCs

Looks like y're in for a hell of a job sorting that out ...
Y'll have to trace all applications as to what kind of controls y're using,
whether they're
standard Office VBE controls, the references in yr projects, the supporting
files these references
need ... etc.

Good luck !

Krgrds,
Perry



Quote:
> I have a few Excel templates that I use that I have added some VBA backed
> buttons to. When others in the company try to open them, they crash and
> leave them inthe VB design window with an error message. The message
varies,
> but the upshot is that their machines do not support the functions that I
am
> using, whereas mine does. (I have a full suite of developer's apps
including
> Visual Studio, whereas they have OEM Office 2K or XP). For instance, they
> might break on the Environ function with an error of "Unknown library or
> object". Question:

> What extras do I need to install on their machines to give them full VBA
> functionality ?? They already have EVERYTHING checked on their Office
> installation from the Small Business OEM CD.

> thanks, P



Wed, 20 Jul 2005 07:20:05 GMT  
 Client's machine crash on VBA in Excel
Tell me about it... Natch I was hoping for something simple like the "Hey
Stupid, you gotta have xyz.dll (download from miscrosoft here.com) to run
VBA, everybody knows that!". But alas it was not to be.

I have tracked it down to be MAPI32.dll which was missing from my clients.
The interesting thing is, while I _was_ using email functionality (attached
to a SUBMIT button), the error, and where it blew apart, was on the ENVIRON
function in WorksheetOpen.

Thanks for your interest, RFP

Quote:
> Hi Randy,

> > using, whereas mine does. (I have a full suite of developer's apps
> including
> > Visual Studio, whereas they have OEM Office 2K or XP).
> and
> > functionality ?? They already have EVERYTHING checked on their Office
> > installation from the Small Business OEM CD.
> Y're making use of several libraries, dll's and ocx files that aren't
> registered on the
> user's machines, that's clear.

> > What extras do I need to install on their machines to give them full VBA
> > functionality ??
> Oops, that's a question we can't answer because we don't know what y're
> making use of, and what is missing on the target PCs

> Looks like y're in for a hell of a job sorting that out ...
> Y'll have to trace all applications as to what kind of controls y're
using,
> whether they're
> standard Office VBE controls, the references in yr projects, the
supporting
> files these references
> need ... etc.

> Good luck !

> Krgrds,
> Perry



> > I have a few Excel templates that I use that I have added some VBA
backed
> > buttons to. When others in the company try to open them, they crash and
> > leave them inthe VB design window with an error message. The message
> varies,
> > but the upshot is that their machines do not support the functions that
I
> am
> > using, whereas mine does. (I have a full suite of developer's apps
> including
> > Visual Studio, whereas they have OEM Office 2K or XP). For instance,
they
> > might break on the Environ function with an error of "Unknown library or
> > object". Question:

> > What extras do I need to install on their machines to give them full VBA
> > functionality ?? They already have EVERYTHING checked on their Office
> > installation from the Small Business OEM CD.

> > thanks, P



Sun, 24 Jul 2005 22:39:20 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Problem with Excel's VBA: SQLOpen and SQLClose Cause Crash

2. Using a Server machine's Access Database from a clients machine

3. HELP - Richtext box crashing client machine?

4. Compatibility Problem Using MS Excel 97 VBA on Excel 2000/XP - Causes crashes

5. Why a compiled executable won't run on client's machine

6. NEW VBA'er(Excel) looking for other VBA'ers

7. MDE's will not run on different machines - sudden Access crash

8. Getting client side machine's name.

9. CTL3DV2.DLL disappearing from client's machine

10. ******** activex document won't work on client machine ***********

11. Getting client side machine's name.

12. Creating Text File on Client's Local Machine When Accessing Web Default Page

 

 
Powered by phpBB® Forum Software