If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

report manager

Thread starter RandyB
Start date Sep 13, 2002

RandyB

New Member

Sep 13, 2002

I've got a button that does this

Private Sub CommandButton1_Click()
Application.ExecuteExcel4Macro String:="Report Manager"
Application.ExecuteExcel4Macro String:="Report Manager"
Application.ExecuteExcel4Macro String:=" REPORT.PRINT(""PRINT ALL"",1)"
End Sub

But to make this work I have VIEW...REPORT MANAGER...CLOSE

And then the button works
I only have to do this once while excel is open
Is there a work around?

I believe I catch the command line <<opening...report.xla>>

I have the report manager checked for an add in.

Ok try this...
With report manager checked
Close excel
reopen excel
(notice report manager is still checked)
try macro
does not work

at least on my machine