Automatically refresh workbook with a Power Query to another file

[albertan]

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.

 

[alansidman]

Click on the Connections Icon on the PQ tab and modify.

 

[albertan]

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.

 

[El Cid]

https://www.mjtnet.com/pricing.htm
Macro Scheduler Pro. Probably the cheapest one out there.

 

[El Cid]

I was wrong...Also the following...and there is probably more out there in the wild.
https://www.uipath.com/solutions/technology/macro-recorder
https://www.autohotkey.com/ [free]
https://www.jitbit.com/macro-recorder/
https://www.winautomation.com/product/all-features/macro-recorder/
http://www.mouserecorder.com/

 

[Nick Burns]

Does the .BAT file have to be on a network drive?

I automate a lot of Excel macros with Task Scheduler.

 

[El Cid]

https://superuser.com/questions/640...uler-job-access-a-mapped-network-drive#641962
I don’t think the .bat or .cmd file can be on a network drive since task scheduler is looking solely on the local machine for the file to start the process. As to accessing a network drive, this link discusses a couple of options.