Hello
I've written a simple macro to open other workbooks. The workbooks are set to refresh data connections to an Access database when they are opened. They do it when I open them manually but not when I run this macro. Can anyone see what the problem is?
Thank you
I've written a simple macro to open other workbooks. The workbooks are set to refresh data connections to an Access database when they are opened. They do it when I open them manually but not when I run this macro. Can anyone see what the problem is?
Thank you
VBA Code:
Sub OpenDataSheets()
Workbooks.Open "E:\Documents\Excel Analysis\BaAnalytics.xlsm"
Workbooks.Open "E:\Documents\Excel Analysis\BoAnalytics.xlsm"
Workbooks.Open "E:\Documents\Excel Analysis\GrAnalytics.xlsm"
End Sub