Hi All,
I am using the following simple VBA to refresh an MS Query when opening an Excel spreadsheet (Because one of my users has a MAc so I cant use Power Query):
Option Explicit
Private Sub Workbook_Open()
ThisWorkbook.RefreshAll
End Sub
The refressh works, but requires me to enter the password, however I d not want users to have to enter a password everytime they open the spreadsheet. Can someone assist with a modification to the code so that it also inputs the password "query" and the runs and the user does not have to enter the password manually
Thank you
Herbz
I am using the following simple VBA to refresh an MS Query when opening an Excel spreadsheet (Because one of my users has a MAc so I cant use Power Query):
Option Explicit
Private Sub Workbook_Open()
ThisWorkbook.RefreshAll
End Sub
The refressh works, but requires me to enter the password, however I d not want users to have to enter a password everytime they open the spreadsheet. Can someone assist with a modification to the code so that it also inputs the password "query" and the runs and the user does not have to enter the password manually
Thank you
Herbz