I am trying to create a VBA script (macro) that will
allow me to run a report manager function from a button
on a spreadsheet.

I recorded a macro of running the report manager function
and received this for code:

Application.ExecuteExcel4Macro String:="Report
Manager"
Application.ExecuteExcel4Macro String:="Report
Manager"
Application.ExecuteExcel4Macro String:= _
"REPORT.PRINT(""Profit and Loss Report
Bundle"",1)"

I then put this code in the buttons on click event and
try to run it but nothing happens.

If I run the report manager function from the menu first
and then run the macro via the push button all works as
expected.

In the doc on the ExecuteExcel4Macro function I found the
statement:

The Microsoft Excel 4.0 macro isn't evaluated in the
context of the current workbook or sheet. This means that
any references should be external and should specify an
explicit workbook name. For example, to run the Microsoft
Excel 4.0 macro "My_Macro" in Book1 you must use "Book1!
My_Macro()". If you don't specify the workbook name, this
method fails.


This leads me to believe that I need to tell the
functions where they are coming from. I have tried every
syntax that I can think of and am not able to resolve
this issue.

Any help would be appreciated (as you probably can tell
by the way I refer to things VBA is not my strong suite).

TIA...