Runtime files of MS Excel

[harshadd]

Hi guys,
Have developed a VB 6 project which gives a report in Ms Excel pivot table.
It works fine with all the systems having ms office (with excel off course) installed.
But with any system not having excel it searches for excel...
I wish there could be some thing like "run time excel".. is there anything like this?

rgds
HarshadD

[Stang02GT]

If i am understanding this correctly your VB app isn't working when Excel isn't installed on the PC?


If thats the case it shouldn't work because if the app was written for Excel and Excel is not installed on the machine it would only make sense that it's not going to work.

[harshadd]

so which files do i need to copy / registered with OS so that OS feels Excell is persent?

[Stang02GT]

You'll need to actually install Excel .

[harshadd]

Except that?????????
Coz Its not my Home to install what ever I like, (My BOSS said)
there are Lincence Isuues connected to it. I want my application tobe used by many people in company, but all are not having MS office on there desktop.

[Stang02GT]

Hi guys,

It works fine with all the systems having ms office (with excel off course) installed.
But with any system not having excel it searches for excel...
HarshadD

Right there you are answering this question for your self. This is NOT going to work unless Excel is installed on the machine simple as that. If you cannot install it then your project will not work!

Have your boss fork out the money to buy licenses for Excel or develop something else that doesn't require Excel.

[Nepomuk]

You could of course try to make it work with a free alternative like OpenOffice. That can create MS Excel files too.

Greetings,
Nepomuk

[harshadd]

I know OpenOffice, but unfortunately it do not create Pivot Tables as excel.

[harshadd]

Hi
I want to use excel9.olb to create excel object without having excel 2003 installed
to use this file with com application , this file needs to convert into dll which can be done using tlbimp.exe (sdk 2.0)
But not able to use this excel.dll with VFP application as it is giving "Entry point not found" error.
can any 1 pls put some light on this?
c++ equivalent code and logic is Here

[Stang02GT]

Hi
I want to use excel9.olb to create excel object without having excel 2003 installed
to use this file with com application , this file needs to convert into dll which can be done using tlbimp.exe (sdk 2.0)
But not able to use this excel.dll with VFP application as it is giving "Entry point not found" error.
can any 1 pls put some light on this?

Yes STOP TRYING TO DO THINGS WITH EXCEL WHEN ITS NOT INSTALLED ON YOUR MACHINE.


You either need to install Excel or stop trying to do things with it when it's not installed

[harshadd]

Stang02GT, pls be positive
This is a programtic need. there are so many other s/w in industries which creates excel files from their applications
similarly
I want to use excel9.olb to create excel object without having excel 2003 installed
to use this file with com application , this file needs to convert into dll which can be done using tlbimp.exe (sdk 2.0)
But not able to use this excel.dll with VFP application as it is giving "Entry point not found" error.
can any 1 pls put some light on this?
c++ equivalent code and logic is HERE

[Stang02GT]

Stang02GT, pls be positive
This is a programtic need. there are so many other s/w in industries which creates excel files from their applications
similarly
I want to use excel9.olb to create excel object without having excel 2003 installed
to use this file with com application , this file needs to convert into dll which can be done using tlbimp.exe (sdk 2.0)
But not able to use this excel.dll with VFP application as it is giving "Entry point not found" error.
can any 1 pls put some light on this?
c++ equivalent code and logic is HERE

I apologize for flying off the handle like that.

I looked through your example site and if you are trying to do the same thing they are, and are getting that error, it seems to me the reason for the error is because you don't have excel. If you are trying to do what the link is showing it is trying to create a spread sheet in excel or your trying to enter an array to a spread sheet.

So with out excel how is this going to work? Entry point not found tells me that the cell your app is looking to enter data in can not be found, probably because you don't have Excel. No excel no entry point for your code to insert anything. Hence the reason for your error.

I am just completely lost as to how you can write sometihng for Excel and not have it installed on your mahcine to see if it works.

[harshadd]

No Stang02GT
I am trying this on workstation having EXCEL, because I wanted to see if it works atall.
As I goggled b4, I found (Came to know) that all the Objects and there properties are gathered into 1 file called excel9.olb, VFP/VB can not use OLB files directly, but SDK 2.0 provides an utility to convert this olb files in DLL
I converted and also d/loaded ready made excel.dll but none is getting registered using regsvr32.exe (Entry point not found error came here), even when i tried to use reference of this files into VB6 it did not allowed to use this.
Declare function of VFP also fails to use this DLL
After scouring the web for a simple Excel header file I came upon
some code at MS expressly for VFP that takes OLB (Office Library
Object files, "OLB"), extracts the constants and lets you save out
as a wholely horrific handy header file, to alliterate. OLBs are
used in the original "Mighty 7".
Microsoft Word 2000 MSWord9.olb
Microsoft Excel 2000 Excel9.olb
Microsoft Access 2000 MSAcc9.olb
Microsoft PowerPoint 2000 MSPPT9.olb
Microsoft Outlook 2000 MSOutl9.olb
Microsoft Graph 2000 Graph9.olb
Microsoft Binder 2000 MSBdr9.olb

Go to MS site to check this