Start instance of Excel with VB

When using the package and deployment wizard of VB, I have been told that even though I include Excel.exe as one of the files in the project, the computer still must have Excel loaded on it before Excel will run. Is this true. And if so, would it still be necessary to include Excel.exe. in the package and deployment process?
GeneSchneiderAsked:
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.

bpmurrayCommented:
Excel.exe is just one of the files in MS Office. It needs a bunch of DLLs and a whole load of entries in the registry, so even if you include Excel.exe in the package, the application won't run on its own.
0
Shanmuga SundaramDirector of Software EngineeringCommented:
I hope that if you create a build using package and deployment Wizard in vb6 then it would run.
0
bpmurrayCommented:
Just to clarify my comment above: if the machine on which you install your application has Excel installed, yes, it will run. However, you can't install it from the copy installed on your machine.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

GeneSchneiderAuthor Commented:
Can you tell me why the wizard includes Excel.exe if it will not work? I ask because I am trying to deploy my app and am having some difficulties.
0
bpmurrayCommented:
It will launch on the target machine if it's installed there. The restriction is that you can't install it from your application, and the message you're seeing is a warning explaining this. Are you using Excel in your app? If not, you can simply remove that from the project.
0
GeneSchneiderAuthor Commented:
I am using Excel in my app. I open an instance of Excel and write data to a spreadsheet. My concern is if someone wants to use my app and they do not have Excel previously loaded, my app will not run. If it will not run because they do not have Excel previously loaded then I will need to change my app because I do not want my customers to have to go out and buy Excel.
0
bpmurrayCommented:
An alternative is, of course, to use some other mechanism to write the spreadsheet. Does your app have to be written in VB? If you're willing to use Java, you could use the POI libraries (http://poi.apache.org/). Of course, you could also refactor your app to use whatever application is available to access Excel files, and if none is installed, point the user to OpenOffice (http://www.openoffice.org/), and use that instead of MS Office. It's free and has most of the functionality of Excel, including the ability to read & write XLS files. Of course it has the extra advantage of supporting the OpenDocument Format, something Office is not yet able to do.
0
ee_rleeCommented:
hi

check this out
http://planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=29672&lngWId=1

it is capable of creating an spreadsheet without any references.
0
GeneSchneiderAuthor Commented:
Sorry of the delay in getting back to everyone. I posted my question and then a couple of days later went on vacation. Then when I returned from my vacation I was in a car accident.

If I understand everything that was written so far. my app will not run unless Excel was previously loaded on my customers machines. Is this correct?
0
bpmurrayCommented:
Yes. While you can reference Excel all you want in your app, unless it's already installed on the customer's machine, the app won't run and cannot install it.
0

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
GeneSchneiderAuthor Commented:
Thanks. I guess I could always add a text box asking if the user has Excel loaded. If yes, then go ahead and use the Excel portion of my app. If no, then disregard all Excel referances.
0
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
Programming

From novice to tech pro — start learning today.