AnsweredAssumed Answered

vrf Vee-Excel Despair

Question asked by gregwale on Jun 7, 2004
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

> -----Original Message-----
> From: Baranski, Detlef []
> 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 []
> 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 (
> 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

You are currently subscribed to vrf as:
To subscribe send a blank email to "".
To unsubscribe send a blank email to "".
To send messages to this mailing list,  email "". 
If you need help with the mailing list send a message to "".