AnsweredAssumed Answered

vrf ActiveX automation and Excel

Question asked by VRFuser on Feb 9, 2005
Has anyone ever come across these issues?


> Hello This is the first time to posting a request to this
> group.  I have two questions dealing with ActiveX automation
> and Excel.
>
> 1- I have a functioning Vee program and would like to save
> the Excel file as a tab delimited file. Using the Function
> and Object browser, the following command is given
> "worksheet.SaveAs(Filename, FileFormat, Password,
> WriteResPassword, ReadOnlyRecommended, CreateBackup,
> AccessMode, ConflictResolution, AddToMru, TextCodepage,
> TextVisualLayout, Local);"
>
> But when I run the program with the SaveAs command I get the following
> error:
>
> Vee Run Time Error
> Execution of mother "SaveAs" in the Referenced ActiveX object Failed.
>
> Error Number: 552
> System error code: 0x8002000e (-2147352562)
> System error message: Invalide number of parameters.
>
> Object title:workbook.SaveAs(Filename, FileFormat, Password,
> WriteResPassword, ReadOnlyRecommended, CreateBackup,
> AccessMode, ConflictResolution, AddToMru, TextCodepage,
> TextVisualLayout, Local); Object
> type: Formula In Userfunction: ExcelHandler
>
> I was wondering if someone had found a work around, Please
> use the file that comes from the help examples "Excel97a
> Ufunction Lib.vee" to work through the problem?
>
> 2- I am trying to understand and get working the ability to
> open several sheets in one Excel file.  I was wondering if
> someone would be able to help me with that using the Excel97a
> Ufunction Lib.vee file that is part of the help examples?
>
> Thank you for your help. 
>
> Philippe Faure
> Design Engineer
> EMS Technologies.
> 613-727-6277 x1298
>
> ---
> You are currently subscribed to vrf as: faure.p@emssatcom.com
> To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
> To unsubscribe send a blank email to
> "leave-vrf@it.lists.it.agilent.com".
> To send messages to this mailing list,  email "vrf@agilent.com". 
> If you need help with the mailing list send a message to
> "owner-vrf@it.lists.it.agilent.com".
>

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes