Run-time error '50003': Unexpected error

J

Jack

Hello,
I have this error, which happens only in Vista.
It happens just at the start of Form_Load routine.
My program is using Excel automation, and I traced the problem is related to
Excel version installed on target computer.
I developed and compiled executable in Excel 2007 environment, but on Vista
there is Excel 2003 installed.
1.
Why the error happens only in Vista?
I have tested executable in WinXP running the same Excel 2003 and there is
not any error.
2.
What else can I do to prevent that problem, besides recompiling exec in
Excel 2003 environment?
Your comments appreciated,
Jack
 
S

Steve Easton

Jack said:
Hello,
I have this error, which happens only in Vista.
It happens just at the start of Form_Load routine.
My program is using Excel automation, and I traced the problem is related to Excel version installed on
target computer.
I developed and compiled executable in Excel 2007 environment, but on Vista there is Excel 2003 installed.
1.
Why the error happens only in Vista?
I have tested executable in WinXP running the same Excel 2003 and there is not any error.
2.
What else can I do to prevent that problem, besides recompiling exec in Excel 2003 environment?
Your comments appreciated,
Jack
Click to expand...

If the development machine has both 2007 and 2003 installed,
set a reference to Microsoft Excel 11.0 object library instead of the Microsoft Excel 12.0 object library
and recompile.

Vista with 2003 has no clue what the Microsoft Excel 12.0 object library is,
hence the error
 
J

Jack

Steve Easton said:
If the development machine has both 2007 and 2003 installed,
set a reference to Microsoft Excel 11.0 object library instead of the
Microsoft Excel 12.0 object library
and recompile.

Vista with 2003 has no clue what the Microsoft Excel 12.0 object library
is,
hence the error
Click to expand...
Thank you, Steve.
Jack
 
M

MikeD

Why are you such as ass?

YOU'RE the one asking for help. If anybody asks YOU a question or requests
additional information in order to help YOU, just answer and don't be a
friggin' moron!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Excel 2007 not in foreground when launched in Vista or Windows 7 4
Run-time error 57121 "Application-defined or object-defined error" 5
Problem in Vista 1
"Run-time error '1004' 5
Problems saving XML file: Run-time error 2
automation error when closing excel 3
problem with "file not found" calling a dll from VBA 6

Top