Forum Discussion

afifhazim's avatar
afifhazim
Copper Contributor
Feb 17, 2023

Automate query schedule refresh in Excel while file is not open

Hi, is there a way to automate query refresh in Excel while not opening the file?
excel
office 365
HansVogelaar's avatar
HansVogelaar
MVP
Feb 17, 2023

afifhazim 

Press Alt+F11 to activate the Visual Basic Editor.

Double-click ThisWorkbook under Microsoft Excel Objects in the Project Explorer pane on the left hand side.

Copy the following code into the ThisWorkbook module:

Private Sub Workbook_Open()
    Me.RefreshAll
End Sub

Switch back to Excel.

Save the workbook as a macro-enabled workbook (*.xlsm),

Make sure that you allow macros when you open it.

afifhazim's avatar
afifhazim
Copper Contributor
Feb 18, 2023

Hi HansVogelaar ,

Thank you for your reply. Unfortunately your suggestion does not meet my requirements. I can also trigger my query to automatically refresh when I open the file through the query properties like in the screenshot below. 


But what I am looking for is to automate query refresh without even opening the file. I am not sure if it is possible or not. 

Resources