macro to open password protected file - want to include password

[pendle666]

Hello

I have written a macro to open an Excel 2010 spreadsheet which I use reguarly. This file is password protected and although I included the password in the recording, it's not in the macro.

What should I do next? Is it possible.

regards

Pendle

 

[madonnac]

Workbooks.Open Filename:= "Z:\MyFile.xlsx", Password:= "MySecret"

there are many options available on the Open command:

[tt].Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad)[/tt]