Re: OLE Automation

This means that the file upload did not work right. Are you sure that your script is correct? Try using the Upload.fwx sample script, which was installed in the examples sub-directory of your program root.

If you can't figure this out send us the original file, the file that was saved on the server with your script, and the source code of the script itself.

FoxWeb Support Team
support@foxweb.com email

Sent by Fox JW on 09/04/2002 11:34:59 PM:

I can't open the file that used the WriteFile() command to copy - same message prompted in Excel "Unable to read file".

But I can open the one manually copy into the server.

Sent by FoxWeb Support on 09/03/2002 08:33:52 PM:

First of all you need to determine whether the file is corrupted or not. Try opening it in Excel first. Also, try manually copying a file to the disk and see if you can open it.

FoxWeb Support Team
support@foxweb.com email

Sent by Fox JW on 08/30/2002 01:13:12 PM:

I have loaded a copy of Excel 2000 and it has started within Foxweb. Problem solved!

But I have another problem. After copied the XLS file into the server, I use Excel.application to open the file and Foxweb prompted error message "Unable to read file" at the following line :

loExcel = CreateObject("Excel.Application")

loExcel.Application.Workbooks.Open("C:\MyApp\Excel\testbook_12345.xls")

I used WriteFile() to copy the XLS file over to the web server before using Excel.application. The file seems to be corrupted.

I really need some help on this part of the program as I'm new using OLE with FoxWeb.

Thanks & Regards

Sent by FoxWeb Support on 08/30/2002 11:50:31 AM:

I believe you do. The Excel.application component is actually Excel itself, so there's no way to load it if it does not exist on the server.

FoxWeb Support Team
support@foxweb.com email

Sent by Fox JW on 08/29/2002 09:04:42 PM:

I got this error message :

"Class definition EXCEL.APPLICATION is not found."

at this line of my program :

loExcel = CREATEOBJECT("Excel.application")

Do I have to install a copy of the Excel into the webserver where FoxWeb is installed?

Sent by FoxWeb Support on 08/29/2002 12:22:11 PM:

FoxWeb scripts are hosted by the native VFP engine, so you have all of VFP's capabilities, including the ability to open Excel sheets.

FoxWeb Support Team
support@foxweb.com email

Sent by Fox JW on 08/29/2002 10:26:36 AM:

I need to let users to extract data from multiple worksheets into a dbf and display the data in the browser. Can I use OLE MS-Excel through FoxWeb? Any tips?