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".
> 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".
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: 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".