AnsweredAssumed Answered

vrf TI floating point to Vee real32

Question asked by michael.l.brown on Feb 8, 2005
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: 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