Hello,
For the word and excel application objects, we can provide "password" in the open method. But, powerpoint does not seem to provide in the open method of "Presentations" object.
Is there some way to send the password.
Thanks,
Mohan
Hello,
For the word and excel application objects, we can provide "password" in the open method. But, powerpoint does not seem to provide in the open method of "Presentations" object.
Is there some way to send the password.
Thanks,
Mohan
From the VBA Help files:
Does something like this answer your question?Password Property
See AlsoApplies ToExampleSpecifics
Returns or sets a String that represents a password that must be supplied to open the specified presentation. Read/write.
expression.Password
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example opens Earnings.ppt, sets a password for it, and then closes the presentation.
Sub SetPassword()
With Presentations.Open(FileName:="C:\My Documents\Earnings.ppt")
.Password = complexstrPWD 'global variable
.Save
.Close
End With
End Sub
Regards,
Brandtrock
Hello Brandtrock,
Thanks for your reply.
My target is to open powerpoint application object invisibly and perform some work without any user interactions.
This works fine until I land into password protected powerpoint slides. In this case, the password dialog is displayed to the user.
I would like to either skip such ppts or provide a wrong password automatically so that ppt quits immediately.
The end result is that user need not do any interactions.
Happy New Year.
Thanks,
Mohan