Read/Write Excel - DLL ??

I have a vb6 program that reads and writes an Excel Worksheet. Now this works fine on the developement machine, but when I made a project and installed onto another PC there I get an Error. It seems to b missing a neccessary DLL.

What DLL do I need to include for this to work??
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

what is the exact Error what does it say.. or is it just a number....
Have you set a reference to the Excel object library for your version of Excel?

There are several Dlls required by VB6 - here's a the main ones:


If you want you could copy them accross, but normally you would use something like The Package and Deployment Wizard - this builds an installation package which the user will run in order to install all neccesary components on to their machine.

The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Does the target machine have Excel installed?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
If you used any scripting make sure the Package & Deployment Wizard included the scrrun.dll
Éric MoreauSenior .Net ConsultantCommented:
As Lewy said, you ABSOLUTELY need Excel to be installed on the user's PC.

The Package & Deployment Wizard (or InstallShield or Wise Installation or any other) won't distribute Excel (Word or Visio or Explorer or Project or ... any applications used by OLE Automation) because you don't have right to distribute it.
eeevbeeeAuthor Commented:
Here are answers, comments...

Development Machine is win98, target machine is WinNT

All the compenents that NikWhitfield mentioned are there

scrrun.dll is in WinNT\system32 but not in the package

I did use the VB setup package to create the setup

>>Have you set a reference to the Excel object library for your version of Excel?

probably not. What am I to do?

Error message:
activex component can't create object

eeevbeeeAuthor Commented:
one more thing

the target machine does NOT have Excel installed.
Éric MoreauSenior .Net ConsultantCommented:
It have too! You have no other choices. PDW CAN'T distribute Excel.
eeevbeeeAuthor Commented:
It needed Excel. I figured that this would be handled by some of VB's .dlls.

But to  whome do I give the points?
Éric MoreauSenior .Net ConsultantCommented:
>It needed Excel. I figured that this would be handled by some of VB's .dlls.

VB don't handle them 'cause of the distribution rights.

>But to  whome do I give the points?
It seems that you have the choice between Lewy and me.
eeevbeeeAuthor Commented:
i am taking Lewy's as it was first, and and I am posting another fantom q for u to answer so that I can give you points too. thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.