Workbooks.Open Macro Not Refreshing Access Data

[andybason]

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

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

 

[Legacy 456155]

I don't know. This is just a stab in the dark.

Sub OpenDataSheets()

    Workbooks.Open("E:\Documents\Excel Analysis\BaAnalytics.xlsm").RefreshAll
    Workbooks.Open("E:\Documents\Excel Analysis\BoAnalytics.xlsm").RefreshAll
    Workbooks.Open("E:\Documents\Excel Analysis\GrAnalytics.xlsm").RefreshAll
    
End Sub

 

[andybason]

Thank you. That has fixed it

 

[Legacy 456155]

Hurray!