Password protected? help!!

J

Jason

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.
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
D

Duke Carey

You're trying to open an Excel workbook file?

Open() method for workbook objects includes an optional parameter for a
password
 
Top