Automatically refresh workbook with a Power Query to another file

A

albertan

Member
Joined
Nov 9, 2017
Messages
30
Reaction score
0
Points
6
Location
Canada
Excel Version(s)
2013
Hello,
I have a file which is linked to another file thought a Power Query. I have a macro that refreshes the workbook upon the opening the file.

Is there a way for me to write an automated script so that it can automatically refresh this workbook every 2 weeks?

Any comments are appreciated. Thanks.
 
Click on the Connections Icon on the PQ tab and modify.
 

Attachments

  • Capture.JPG
    Capture.JPG
    60.2 KB · Views: 30
Thank you for your reply. I need to clarify my question. I need to schedule the automated refresh (say on a weekly basis). I'm trying to get Task Scheduler work based on .bat and .vbs files. However, I'm having issues accessing a .bat file unless it is on a C drive.
 
Does the .BAT file have to be on a network drive?

I automate a lot of Excel macros with Task Scheduler.
 
You must log in or register to reply here.
Back
Top