Need macro to open excel sheet that is password protected

[sokker23]

Hello. Part of the macro I am using opens an excel workbook that is password protected. When I run the command to open the workbook I get the password pop up and cannot continue until I enter the password. I am looking for a way to have the macro enter the password for me so I do not need to manually type in the password to proceed with the macro. The password pop up follows immediately after I open the workbook so I am thinking I may need a command within the open command because once the workbook opens the macro stops. Any help is greatly appreciated. Below is the command I am using to open the workbook, which is immediately followed by the password pop up box.

Workbooks.Open Filename:="C:\Scripts\24033\Position Reports Comparison Template.xlsx"

[HaHoBe]

Hi, sokker23,

pass the password as well like

Please Login or Register  to view this content.

Ciao,
Holger

[sokker23]

Perfect! That worked great. Thank you.