Including Excel Worksheet in Project

[shastri_s]

I have a small demo appln. wherein Excel should be part of the VB project.Am using Shell command to start Excel. Can I include it as part of the VB project.

Thanks



------------------
Shas

[JHausmann]

Not unless you work out a licensing agreement with M$oft. Your best bet is to *require* anyone running your demo to have Excel installed.

[shastri_s]

Thanks.Suppose So.

[billwagnon]

I don't have details on this, but it is my understanding that with OLE you have quite a bit of the functionality of Excel and the user is NOT required to have Excel on the computer. So if you have a worksheet, you should be able to embed it using OLE, and any user would be able to run the program.

[webman]

OLE (Object Linking and Embedding) is simply a way for one app to call another app and pass info around. You could create a table of data in Word and then link that data (using OLE) to Excel where it turns it into a graph and then link that graph (again using OLE) back into the Word document. In this way you could make changes to the data in the Word document, hit refresh and get an updated graph without having to open Excel again, OLE does it for you. No help at all with trying to use specific Excel features. From within VB you can reference the Excel object and gain access to just about everything a spreadsheet can do, but like
JHausmann said, the user will still have to have Excel on their machine. You do not need to shell out to start Excel though, the app can do that. If that is what you really need, write back and I'll look up the code for you, I've done it, but it's been a few months.

------------------
WebMan

[shastri_s]

What I was looking for is a way for the excel worksheet file to be included in the project so that when I tarnsfer the project/exe to another machine, there is no dependency on paths etc. and I do not have to copy the Excel worksheet separately.

Thanks...

[Manish]

U can use package and deployment wiz which is bundled with vstudio and Vb6.0 it gives u facility to include other files which are nt part of yr project. u can also specify the path where u want to install those files.
hope it will help u.
thanx Manish

[jritchie]

We have started to include alot of export options in our apps to Excel and Word. Generally the majority of our users have Office 97/2000 already so this isn't a problem. Users who don't have office are generally quite happy to purchase it.

In deployment include any pre-recorded worksheets, and use the various shell commands to move the worksheet to where you expect to see it.

[shastri_s]

Thanks a lot, everybody