Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Location
    London
    Posts
    64

    Unanswered: open a password protected powerpoint file

    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.

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151
    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
    --If its free, take it for what its worth!

  3. #3
    Join Date
    Sep 2004
    Location
    London
    Posts
    64
    Stu, thanks for looking into this. Still havent found a solution to the problem myself either, if i do will post here.

    Thanks

    EV

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •