This is more of an excel question but hopefully the VBA soltion will be similar...
I have external data via ms query that I need to refresh when the workbook is opened. I'm using .querytable.refresh in the Workbook_Open event, works fine. The issue is that some users of this file are remote and...