i'm running a excel/vba portal and i'm trying to open a password protected powerpoint file from within the portal. all the excel documents open fine, but i'm having problems getting the powerpoint files to open. pp always requests a password and i can't declare the password in vba. at the moment the code i am using is:

POWERPOINT:
X = ActiveSheet.Cells(7, 13).Value
Dim y As PowerPoint.Application
Set y = CreateObject("PowerPoint.Application")
y.Visible = True
y.Presentations.Open Filename:=X

EXCEL:
X = ActiveSheet.Cells(9, 13).Value
Workbooks.Open Filename:=X, Password:="chuck", ReadOnly:=True

does anyone know of any way i can open powerpoint with a password using vba?

thanks.

Hey,

I just spent about 35 minutes surfing the web and I can't find a command line switch to open a password protected ppt. file. If I do come across one, I'll get it to you.

Stu

Stu, thanks for looking into this. Still havent found a solution to the problem myself either, if i do will post here.

Thanks

EV