AnsweredAssumed Answered

vrf ActiveX for calling VBA funcs from VEE

Question asked by WDrago on Aug 22, 2007
Latest reply on Aug 23, 2007 by VRFuser
All,
 
Assume I am using the Excel Lib and have opened a workbook.
In the workbook are several VBA functions that I need to call from VEE.
Since there are no functions in the Excel Lib for calling VBA funcs I'll need some ActiveX code.
 
I checked the archive and found something that looks close, but I'm not sure:
 
xlApp.Run("ExcelFile.xls!Name_of_VBA_Function");
 
I don't know why I'd have to specify the name of the excel file if I have already opened it.
 
Can anyone help here?
 
Also, does anyone know how to write to a VBA text box? I have to do that too.
 
Thanks,
Bill
 
 

---
You are currently subscribed to vrf as: hua_jing@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes