Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to Excel
Message
 
 
To
17/05/2018 12:53:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01660031
Message ID:
01660051
Views:
42
>>>>>>Hi,
>>>>>>
>>>>>>When exporting data from VFP 9 application to Excel and using the following syntax:
>>>>>>
>>>>>>
>>>>>>EXPORT TO (cExcelFileName) type XLS
>>>>>>
>>>>>>
>>>>>>Does the above require that MS Excel be installed on the PC?
>>>>>>
>>>>>>TIA
>>>>>
>>>>>Hi Dmitry,
>>>>>
>>>>>No.
>>>>>
>>>>>MartinaJ
>>>>
>>>>Thank you, Martina!
>>>>
>>>>If you don't mind, a follow up question, please.
>>>>
>>>>If the Excel automation is done using the following syntax:
>>>>
>>>>oExcel = Createobject("Excel.Application")
>>>>
>>>>
>>>>Does the error 1733 "Class definition EXCEL.APPLICATION is not found" means that Excel is not installed on the PC?
>>>
>>>Yes, Dmitry.
>>>
>>>MartinaJ
>>
>>Thank you, again. The strange thing is that in my app I use the syntax oExcel = Createobject("Excel.Application") and in one place the exporting works. And in another place I get error "Class definition EXCEL.APPLICATION is not found." And I am executing the application on the Remote Desktop (connected to the customer) where, as far as I know, Excel is not installed. Could it be that in one case it "gets" Excel from my PC and in another it does not?
>>
>>UPDATE. I found out that in the place where Export works, the program was using EXPORT TO (cExcelFileName) type XLS (and I will change it per Tamar's suggestion). And in the place where it didn't work, the program was using Createobject("Excel.Application"). And I told the customer to install MS Excel on the servers.
>
>If you want to be nitpicky, oExcel = Createobject("Excel.Application") might fail even if Excel is installed on the machine, directory was moved later, but Excel still works if the exe is clicked directly in moved directory (might show some nag screens, but works later on).
>
>But as the Registry entry is wrong, automation probably will fail.

Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform