AnsweredAssumed Answered

vrf Vee-Excel Despair

Question asked by gregwale on Jun 7, 2004
Detlef,
Yes, just substitute your excel application object variable for xl in the
code I sent (shown below) to crate and run a VBA macro in Excel.
Good luck
Greg

> -----Original Message-----
> From: Baranski, Detlef [mailto:Detlef.Baranski@PILKINGTON.de]
> Sent: Monday, June 07, 2004 4:46 AM
> To: 'Greg Wale'; VRF
> Subject: [vrf] RE: Vee-Excel Despair
>
> Maybe this is an ,...hmm,... "unwanted" question, but is this perhaps
> possible without the use of VXL ?
>
> best regards,
> detlef
>
>
> -----Ursprngliche Nachricht-----
> Von: Greg Wale [mailto:gregwale@passtechnologies.com]
> Gesendet: 06 June 2004 07:42
> An: VRF
> Betreff: [vrf] RE: Vee-Excel Despair
>
>
> I'm jumping in semi-blind not reading the entire transcript, but perhaps
> this can help. Have you considered calling a macro in VBA and letting it
> do
> the work, instead of doing all the Excel work from VEE? If that seems like
> a
> useful idea, it might be helpful to know how to create a macro (so you
> don't
> have to have the macro in the same workbook), which there is an example
> for
> in Vxl (www.passtechnologies.com)
> Here it is for what it's worth:
>
> Set VbModule=xl.ActiveWorkbook.VBProject.VBComponents.Add(1);
> VbModule.CodeModule.AddfromString("Sub MyMacro : msgbox(" + intToChar(34)
> +
> "Hello World from " + xl.Caption + intToChar(34) +")    : End Sub");
> xl.Run("MyMacro")
>
> All the macro does is show a msgbox, but if you have a macro that does the
> sort stuff you want, replace the msgbox code with the sort code and try it
> out.
>
> Regards,
> Greg
>
> This message and any attachments are confidential, for the exclusive use
> of
> the addressee and may be legally privileged. Any other distribution, use
> or
> reproduction is unauthorised and prohibited. If you have received this
> message in error, please notify the sender immediately and delete the
> message from your system.
>
> Visit our internet site at http://www.pilkington.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