[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Re: Choosing which macro to call

NickHK

12/13/2006 2:46:00 AM

Neal,
As for the code generation part, you can work with the VBE in code :
http://www.cpearson.com/exc...

Note also that XL2002 and up have an additional security option of
Tools>macro>Security>Trusted Sources>"Trust Access to VB Project"

NickHK

"Neal Zimm" <nealzimm@yahoo.com> wrote in message
news:F56B33FC-B7F4-4322-A70E-544ED2478E5E@microsoft.com...
> In other languages, notably SAS, a macro can generate source code which
> is then executed. Does such a capability exist in VBA ? (Based on what
I've
> read so far, I think the answer is no.)
>
> Currently, I have situations where, as an example in pseudo code ....
>
> If varname = value then
> call this_macro
> elseif varname = thatvalue then
> call that_macro
> end if
>
> I'm look for a 'more direct' way to do the above. Is this possible?
> Thanks.
> --
> Neal Z