What is the VBA to put the password in the prompted box
Dave as you see my VBA in other postings, I have supplies the password in the
Getopen filename, but it does not work.
Could you help me how can we write it, what is wrong with my VBA
Thanks
Frank
"Dave Peterson" wrote:
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
|