software

hi, i am trying to open a password protected file from vba, i know the
password for the file, but is there anyway that i could include the password
in the coding so that it would not promt for password?, pls help.

Application.DisplayAlerts = False 'shuts off the pop-ups
Your code here...........
Application.DisplayAlerts = True 'turns things back to normal

Vaya con Dios,
Chuck, CABGx3

quot;Jasonquot; wrote:

gt; hi, i am trying to open a password protected file from vba, i know the
gt; password for the file, but is there anyway that i could include the password
gt; in the coding so that it would not promt for password?, pls help.

You're trying to open an Excel workbook file?

Open() method for workbook objects includes an optional parameter for a
password
quot;Jasonquot; wrote:

gt; hi, i am trying to open a password protected file from vba, i know the
gt; password for the file, but is there anyway that i could include the password
gt; in the coding so that it would not promt for password?, pls help.