Opening a password protected project file using GetObject

T

ToddR

I am trying to incorporate the use of project data in an Excel macro using
the "GetObject" command. However, the project is password protected and
invokes a dialog box requesting the password or a selection of 'Read Only".
How do I automatically select the read only option to avoid manual
intervention to keep the macro moving? If this is not an option, then what
command(s) should I use to permit the equivalent of the following:

Set prj = GetObject("Myproject.mpp")

where Myproject.mpp is password protected, and I want to open it as read
only and be able to read the contents of the project as data with my excel
macro?
 
M

Mike Glen

Hi Todd,

Try posting on the developer newsgroup where the VBA experts hang out!
Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and
other useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using GetObject with Read Only project file. 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Using GetObject to access a Project file but getting Error 70:Permission Denied 0
getObject and password protected workbook 4
'Password is incorrect' when entering the correct one... 0
Getting into a password protected project plan 1
Macros all vanished from my MPP file, can't add them back! 0
How to bypass password when pasting FROM a protected workbook 3

Top