Purpose
Runs a Microsoft Excel 4.0 macro function and then returns the result of the function. The return type depends on the function.
Syntax
ExecuteExcel4Macro(String)
Required Parameters
String
A Microsoft Excel 4.0 macro language function without the equal sign. All references must be given as R1C1 strings. If String contains embedded double quotation marks, you must double them. For example, to run the macro function =MID("sometext",1,4), String would have to be "MID(""sometext"",1,4)".