Hello,
I am hoping you are able to assist.
I am trying to write a macro to open a workbook. The file requires a password to open it - this is my own workbook and i know the password.
Is it possible to write a code (similar to Workbooks.Open Filename etc) that allows you to enter the password automatically. I need to open the file when the macro runs, but not allow others to know the password.
I hope this makes sense.
Many thanks in advance,
Chris
I am hoping you are able to assist.
I am trying to write a macro to open a workbook. The file requires a password to open it - this is my own workbook and i know the password.
Is it possible to write a code (similar to Workbooks.Open Filename etc) that allows you to enter the password automatically. I need to open the file when the macro runs, but not allow others to know the password.
I hope this makes sense.
Many thanks in advance,
Chris