I need read a Excel file, but it has a password.
I could identify the window to enter the password and everything but when I execute it from the object studio, the execution does not run, it stays stuck.
You need not spy the Excel pop up window especially when there is an in-built Ms Excel VBO to perform the operations on Excel.
Refer Post #2 here and the link inside that post to make permanent changes to open any Workbook with a password
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.