You’re offline. This is a read only version of the page.
7
im having the excels file used on power query, would like to refresh the file by using flow. unfortunatly im stuck in "Enable background refresh"
Reference video
https://www.youtube.com/watch?v=4Qoh9t_ZvqI&t=108s
@Wasfi Maybe it worth running VBScript...
' Create an Excel application object
Set objExcel = CreateObject("Excel.Application")
' Open the Excel workbook
Set objWorkbook = objExcel.Workbooks.Open("C:\Path\To\Your\Workbook.xlsx")
' Refresh all data connections in the workbook
objWorkbook.RefreshAll
Check the video tutorial at - https://www.youtube.com/watch?v=j3rjH626OxY
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
