i need to open a protected workbook. Lets say my excel name is abc.xlsx and opens with password 1234.
I need a way to open this with BP using code. Any inputs, please share the exact details.
link doesn't open at my end. I tried the below.
Dim wb as Object = GetInstance(handle).Workbooks.Open(Filename:=filename, Password:=password)
name = wb.Name
wb.Activate()
used a copy of open workbook action and added input parameter password in input. Code runs fine but the file is not opened and neither saved as password unprotected workbook.
The link suggests the same code changes you have posted. I don't think the code change you made will save the file unprotected, it opens the file passing password.
Please share screenshots with the values, if possible.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.