There is no command that will do this for you.

You either need to supply it in your code on the workbooks.open() line (and that
means you have to know the password for each of the files selected)

or

You have to let the user type it in.



Frank Situmorang wrote:

Hello,

When we run the following VBA to open the password protected workbooks, it
will prompt us to fill in the password.

FileNameXls = Application.GetOpenFilename(filefilter:="Excel Files, *.xl*", _
MultiSelect:=True)

I appreciate if some one can tell me the VBA to fill in the password box.

Thanks in advance

Frank

--

Dave Peterson