ole control

[sahr]

I have an application written in vfp 3.0. I write some informtion to an excel document with some code similar to the following.

oleExcel = CreateObject("Excel.Application&quot
oleExcel.application.workbooks.open("BlankExcel.xls&quot
oleExcel.application.worksheets("sheet1&quot.activate

* Fill in Header information
oleExcel.cells(1,1).Value =gcTitle
oleExcel.cells(3,1).value = "Date"
oleExcel.cells(3,2).value = "Time"

oleExcel.ActiveWorkbook.SaveAs(gcFile_Name+".xls&quot
oleExcel.Quit


This code seems to work OK and I use the setup Wizard to create the installation files. It will install fine on a computer that has excel already loaded, but not on one that doesn't. I'm guessing that there is some dll that I need to include with the install but I do not know which one. Any ideas?

 

[RajaYasin]

Cummon Mate.....It Cant Load Something It Does Not Have ... Its Not A DLL That It Needs .... Its Excel.Exe ....

Otherwise We Could All Get Hold Off This DLL and Create Excel Sheets ....


Sorry For Sarcasm!!!

RajaYasin.

 

[foxdev]

I think SAROLANDO's impression is reasonable: the VFP program should install on a machine whether it has Excel or not.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[ChrisRChamberlain]

sarolando

You might check the list of files in your project that you intend to install on the target machine.

It might be that you have included some Excel specific files.

Maybe the setup program cannot locate the Excel folders\subfolders on the target machine and thus cannot complete the installation?

Chris