Hi all,
I know about using Application.Run MacroName:=xxx to run a subroutine/function called xxx at a particular point in code.
However, can one do the following in VBA:
[VBA]
Dim MyString As String
Dim AnotherString As String
MyString = "ActiveDocument.Name"
AnotherString = "Name = " & Application.Run MacroName:=MyString
[/VBA]
where, instead of a subroutine or function, the object I want executed is a variable storing a method (for example).
The use of the backtick substitution operator is common in UNIX shell programming to get the shell to execute the enclosed command stored in the variable at that point in the code.
Does VBA have anything similar to the backtick subsitution operation in shell programming?
Something like:
[VBA]
AnotherString = "Name = " & `ActiveDocument.Name`
[/VBA]
Ed