Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=2)
-   -   Evaluating a macro name with a macro in it (https://www.kinook.com/Forum/showthread.php?t=5353)

mevans 06-02-2015 06:45 PM

Evaluating a macro name with a macro in it
 
Suppose I define a macro like this:
%PHASE%-ReturnErrorCheck

I can successfully assign a value to this macro. It works as expected; however, I'm trying to figure out the notation to get the value out of %PHASE%-ReturnErrorCheck. I've tried various things like:
%%PHASE%-ReturnErrorCheck%
[%PHASE%-ReturnErrorCheck]
%[%PHASE%-ReturnErrorCheck]%

But they don't work.

I found one way to get the value out of it:
[Application.Macros(vbldMacroAll).Item("%PHASE%-ReturnErrorCheck")]

That works, but I'm not too fond of it. I supposed I could wrap it up in a subroutine to make it look nicer. It just seems there ought to be another way to get the value out.

kinook 06-02-2015 08:05 PM

Yep, or

[vbld_AllMacros.Item("%PHASE%-ReturnErrorCheck").Value]

Or create a project or global script function like this:

Code:

Function GetMacro(name)
  GetMacro = vbld_AllMacros.Item(name).Value
End Function

and call like this:

[GetMacro("%PHASE%-ReturnErrorCheck")]


All times are GMT -5. The time now is 05:54 PM.


Copyright © 1999-2023 Kinook Software, Inc.