Excel office automation issue. 1

[iyarosh]

Hello everyone,

I have FoxPro 6 application that does some custom formatting on Excel spreadsheet, which is created by the same application. Everything works fine on my machine, however we have users that use Citrix client to access the server (something similar to PCAnywhere). That is where I'm getting the message "Class definition EXCEL.APPLICATION is not found" while running it off the client software. I'm pretty sure it happens because Citrix server does not have any MS Office components installed and the policy is not to install anything. Would anyone know of any kind of work around this issue. Is there a way to include this class/classes into my project so it will work on the computer without Excel?

Thank you!

 

[Mike Gagnon]

iyarosh

I cannot see how, in Cirix as in PCAnywhere you are using the server as THE computer, it is unrelated to what the computer that is logged has.
[ol][li]This may require either a rewrite of the report's output with an acceptable format that the server will permit. [/li]
[li]Or Install Excel only from MSOffice (which sounds like it might not be possible).[/li]
[li]Forget the formatting and use the copy to...type XL5 and retrieve the Excel to the user's machine.[/li][/ol]

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[iyarosh]

Mike,

Thanks for your reply. I was afraid that it will be the case, but was hoping that there is a way to include needed classes into the project and get it working...

Igor.

 

[Mike Gagnon]

iyarosh

No, it sounds like you are using something like

oExcel = createobject("excel.application&quot

If so it requires Excel to be installed not just some DLLs.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[iyarosh]

Mike,

That is exactly what I'm using...

Thanks again.