You’re offline. This is a read only version of the page.
I have a file with auto-saved turned on, and I'm using "run application" to open it this file during a flow. When opened by PAD, however, the auto-save is turned off.... When I open the file myself, auto-save remains on. I've confirmed that PAD is opening the correct file from the correct folder (Sharepoint synced).
Is there anything I can do...?
Thanks in advance.
Closing this thread. Looks like something wonky with the remote machine, 'cause when I restarted it the problem didn't recur. Thanks for all who tried to help.
I wondered the same, but path is correct. After restarting the remote machine, the problem didn't recur... so I'm moving on. Thanks for your help!
Seems to me like you are opening your local version and not the onedrive version. If you open the onedrive version, the folder will already be connected and the autosave should turn on. If you are opening a local version, the onedrive is not linked which is why it's prompting you to link the onedrive when you switch it to true.
Try the launch excel action again, but point the folderpath/filename.ext directly at the onedrive version.
Good luck!
Thanks Srini. I did try that different method of opening the file with PAD flow, but with the same result (auto-save turned off). When I then toggle the switch to turn it back on, i'm prompted to select my one-drive login, and it then saves the file in the main directory folder and not the original sub-folder location..... thoughts?...
Hi @Murphys110
It's better to use Excel actions instead of using 'run application', As @VishnuReddy1997 suggest try Launch excel action and check
If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION
Cheers,
Srini
Thanks again. Using your code to open the file still produced the same odd result (auto-save turned off). When I then toggle the switch to turn it back on, i'm prompted to select my one-drive login, and it then saves the file in the main directory folder and not the original sub-folder location..... thoughts?
Hi @Murphys110 ,
Launch excel is not a new action.You have lot of in built excel activities as shown in below image.
I have written a sample how to launch excel,read excel and close excel by saving it.Please find the below flow.
Code:
Please copy the below code to your flow.
Share
Report
All responses (
Answers (
5,721Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\Practice\\Excel\\input.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
Excel.CloseExcel.CloseAndSave Instance: ExcelInstance
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
Thanks Vishnu, and I didn't know about "launch excel" (is that a newer feature?).. for now I'm just really curious as to why it would open "off" when it was saved "on", and only happens when PAD opens the file...
I did try the launch excel to see if the issue persists, and it does... odd...
Thanks Michael, and I may use that solution to toggle that switch... for now I'm just really curious as to why it would open "off" when it was saved "on", and only happens when PAD opens the file...
Hi @Murphys110 ,
Unfortunately, there are no documented settings within PAD to directly control auto-save behavior for opened files.
Instead of run application for opening an excel you can go with excel activities such as Launch excel,Close excel,Save Excel etc.
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
