Automating Opening Excel Workbook

[Londa1130]

I have to export information over from MsAccess to print in an Excel spreadsheet. I have a macro in place to automatically update the workbook, but would like to know if there is a way to have the book open automatically on its own. In the window task scheduler I have Excel scheduled to open at a certain time weekly and would the report to run itself.

I need something that opens to trigger the sub OpenMondayReport() but don't have a clude how to do this.

Sub OpenMondayReport()
Dim wkb As String

Filebase = "T:\Real Estate\MondayReports\Monday Reports.xls"
Workbooks.Open Filebase
End Sub

Any help with this would be greatly appreciated.

 

[misscrf]

I would suggest coverting the macro to code, and inserting your open code after the update code. That is if you want it to open right after update.

misscrf

Management is doing things right, leadership is doing the right things