JGupte
04-01-2015, 08:33 PM
Hi,
I have seversl reports that I need to run every week. They are run from Macros that gather info from several other spreadsheets into a formatted spreadsheet.
I would like to create a macro in a generic spreadsheet that will run each of the other macros after opening the spreadsheets.
The code I use is
Sub CallAllReports()
'
' Call All Weekly Reports Macro
'
Call SDDL_Report
Call Package_Report
End Sub
Sub SDDL_Report()
' Call SDDL Report
Application.Run "'\\Aumelbw140a\qdms\Roy Hill\SDDL Report Proc.xlsm'!SDDL"
End Sub
Sub Package_Report()
' Call Package Report
Application.Run "'\\Aumelbw140a\qdms\Roy Hill\Package Report Proc.xlsm'!Package"
End Sub
But this code runs the SDDL Report multiple times and not the Package Report.
How can I run both these reports from my macro?
Cheers,
JG
I have seversl reports that I need to run every week. They are run from Macros that gather info from several other spreadsheets into a formatted spreadsheet.
I would like to create a macro in a generic spreadsheet that will run each of the other macros after opening the spreadsheets.
The code I use is
Sub CallAllReports()
'
' Call All Weekly Reports Macro
'
Call SDDL_Report
Call Package_Report
End Sub
Sub SDDL_Report()
' Call SDDL Report
Application.Run "'\\Aumelbw140a\qdms\Roy Hill\SDDL Report Proc.xlsm'!SDDL"
End Sub
Sub Package_Report()
' Call Package Report
Application.Run "'\\Aumelbw140a\qdms\Roy Hill\Package Report Proc.xlsm'!Package"
End Sub
But this code runs the SDDL Report multiple times and not the Package Report.
How can I run both these reports from my macro?
Cheers,
JG