Error Messages in VBA - General

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,
I made a Program in Excel (with VBA) for which one should have atleast
Office XP as the minimum requirement.
It is running well in Office XP.
But if the program is used in the Office 2003 it is showing error messages
and that too only in some Pc's
Interestingly, it is working fine in many of my collegues PC who are all
having the same Office 2003 (with windows XP as operating system)
In some PC's office 2003 it is not working (although they are having the
same windows XP) .
I couldn't able to find out the reason for this.
Is it because of non-genuine Software?
I am worried about it as I worked on this program for more than 6 months
with the help of our group people.
Please advise me.
Thanks and Regards,
Anand.
 
Anand

It could be a multitude of things.

They may need a full installation of Office
You may be using a reference to a different library and they may need a
reference set in advance
You may be automating a program they do not have
You may not have a program they do that is interfering
You may be importing data via a DSN they do not have
Etc, Etc, Etc

It is down to detective work and nailing down what all the machines your
code does not work with have in common. (Or of course all the machine it
*does* work with have in common)

Also take a look at the machines list of add-ins under tools>add-ins...
(Uncheck all and add back one at a time, re-starting excel between each
iteration)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
Dear Nick,
Thanks for your reply.
Actually, yesterday I worked in it.
It is showing an error called,
"Compile Error in Hidden Module UserForm14"
Then I unprotected my program and then I found the error in a VB Coding
The problem withmy PC is that it is not accepting some VB Codings although
I'm having the same configuration (office 2003 with Windows XP) like others.
For others the program is working fine.
I do not understand why it is happening like this.
Why it is not supporting some VB Functions/Codings?
Why these kind of Strange things are happening?
Please suggest me.
Thanks and Regards,
Anand.
 
Back
Top