Macro to refresh .csv Connection In Workbook - Lose Prompts

[Bench]

Hi,

I'm looking at better ways of importing data from a central spreadsheet into a workbook that drives a dashboard.

I've figured out how to do it, i just need to automate it now.

So far its really simple

Sub Macro2()
'
' Macro2 Macro
'
'
    Application.DisplayAlerts = False
    ActiveWorkbook.RefreshAll
    Application.DisplayAlerts = True
End Sub

This works but each time i run it i have to click OK in a workbook open style dialogue box to select the file to import, how do i avoid having to click ok each time? I thought the Application.DisplayAlerts = False would resolve this but apparently not.

Any help would be appreciated

Thanks

Ben

 

[Bench]

bump