Hi everyone,
I'm just starting to learn Power Automate and Flows. Now I would like to have a Flow of my regular VBA processes automated. I always get an email with an Excel document where only a few pieces of information are of interest to me. I am currently having this read out via VBA. The problem is that the Excel document has a password for opening. Can anybody help me how I can automatically open the document with the same password and export the few information to an Excel document (or list)?
Regards
sakoba
Hi @sakoba1844
You will have to make use of OfficeScripts and then call them from Power Automate.
Refer this link for OfficeScripts.
The above link has a video and also information on using the recorder.
But if you want to know more you can take a look at some videos on YouTube for creating OfficeScripts for Excel.
The official documentation on Excel scripts regarding workbook unprotection is here.
The topic of interest for you in this link would be in below marked section.
PS: the title says sheet protection but the content of the post says the file is asking for password before opening. Both cases you will find in all of the above links.
Hello @sakoba1844,
No u can't, weather it is SharePoint or One Drive it should be Password free excel.
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
That's bad, thank your for your help 😞
Is it possible to temporarily store a copy in my OneDrivefor removing all passwords are automatically and delete this afterwards?
Regards
sakoba
Hello @sakoba1844,
Unfortunately connector does not support based on your requirement to retrieve password protected spreadsheets. There is no way to work with them other than removing the password.
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2