Excel and MSProject automation

[atab]

Hello everyone! this is my first post and was reffered here by friends!

I am currently working on a project that requires me to export information from MS Project and copy it into excel.

The biggest problem im getting is that the files in MS project are located on a server protected with a password. Is there anyway to prompt the user for his/her username/password then open the appropriate file.

In order this is what I would like the macro to do(Keep in mind Im not sure all of this is actually possible)

1. have my Excel file open
2. run the macro --> it asks for username and password
3. opens MS project > enters the password into the fields
4. opens the selected project
5. copies the information from the MS project into the original excel document
6. close the MS project document

** if the password part is impossible that is fine but I recently found out how to do something similar with excel(no password) and was wondering if it would be possible with the added security.

Other solutions are more than welcomed

Thank you so much in advance and i look forward to being a part of this community

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=640193

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).