office automation - any redistributable S/W packages?

Our client machine doen't have any Microsoft office tools (Excel, Word,..). The application we are developing needs MS Excel. Are there any free redistributable S/W packages which can be deployed on client machine?

When the code to access Excel object is executed on the client machine the following error is coming:
COM object with CLSID {00024500-0000-0000-C000-000000000046} is either not valid or not registered.

Can anybody help me what to do to work with Excel object without installing Excel on client machine..

thanx in advance...

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.

Bob LearnedCommented:
What kind of access do you need?  Are you just trying to pull information from an XLS file?
if you are trying to use standard Office Automation, then Excel MUST be installed on the target PC.  There are no work-arrounds.

What are you using the Excel object for?

Bob LearnedCommented:
You can access worksheets in Excel as a recordset using ADO or DAO.
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.

ewizzAuthor Commented:
We have two applications. In application1 we are generating xls file. The generated xls is used in application2. At the client place, application1 will be in one machine wherein Office is not installed and application2 is installed in another machine wherein Office is installed.

Though Excel is not present in machine1 we can always generate tab delimited xls using FileSystem Object. But problem comes when the above tab delimited xls is used in application2. Because application2 expects Workbook.

Is there any wayout to generate Workbook kind of xls instead of a flat file?

How can we use ADO for creating xls. Some sample code would help. Does ADO work even if Office is not present?
Bob LearnedCommented:
Yes, you would use the OLEDB Provider for Jet, which gets installed with MDAC.  

I don't have a lot of time for sample code, but start here with the connection string:

OLE DB Provider for Excel

Have you worked with ADO before?

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
ewizzAuthor Commented:
We tried with ADO for filling Excel file in application1. It is solving our problem to some extent. The only problem remains is: We tried with placing a dummy excel template physically in the client machine. Opened it as database through ADO. After writing our calcuated data to the database (Excel) we are saving the excel with some other name. i.e. the dummy file is always required with this type of code.

Is it not possible to make use of Excel as database without creating any dummy file?
Bob LearnedCommented:
I don't understand what you mean by "dummy template".
ewizzAuthor Commented:
We just created one file with .xls extension and placed in non-Office machine. Everytime we are opening it through ADO and saving it as another .xls. For opening the excel database through ADO we are using that dummy file, which is not good at client's place in the long run.

That is why I am asking if there is any way out without using such intermediate file for ADO.
creating a file with an XLS extension DOES NOT make it an Excel file.  The EXTENSION is NOT what determines what kind of file it is.  That is determined by the internal structure of the file itself, and the internal structure of an EXCEL file is a propietary design owned by Microsoft.  

I can create a free text file, with any text whatsoever, in NotePad and save it as MySample.xls.  This does NOT make it an Excel file, but rather a Texct file with the extension .XLS.  These are NOT the same thing.

ewizzAuthor Commented:
That is true. I completely agree with AW.

As you can see my question is related to that only. Though the dummy file is not true Excel I created it with .xls inorder to open with ADO.
what does a file extension of  .XLS have to do with ADO?  the two are completely independent.

ewizzAuthor Commented:
Can anyone give the steps to open and write some content to an xls file through ADO?
never had to go that route.  All of our customers have Office installed, so trying to work-around has NEVER been an issue, and never will be. Our major customer - US Air Force Headquarters at the Pentagon, in MARRIED to MS Office as their primary application tool, so it will never be a problem.  Sorry but  can't be of any assistance on this.

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
Visual Basic Classic

From novice to tech pro — start learning today.