Thread: What is the VBA to put the password in the prompted box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frank Situmorang[_3_] Frank Situmorang[_3_] is offline
external usenet poster
  
Posts: 36
Default What is the VBA to put the password in the prompted box
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

Reply With QuoteReply With Quote