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.
Thank you so much in advance and i look forward to being a part of this community
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.
Thank you so much in advance and i look forward to being a part of this community