CODEWITHSUNDEEP
vbams-projectdata-connectionsms-project-server-2013
Vince
Vince

Reputation: 33

Create a data connection from MS Project Server to Excel 2007

Hi I have a Project plan which sits on MS Project Server. What would be the easiest way for me to create a data connection which isn't just a one time refresh from Project to Excel with the use of VBA?

I could obviously take an extract manually each time from MS Project to Excel but wondering if there is anything I can use to automate this via a Data Connection in Excel?

Upvotes: 0

Views: 468

Answers (1)

LiriB
LiriB

Reputation: 822

You can create an Excel data connection which uses an identity from the securestore (as described here) and then query the project server database (some sample queries here)

Upvotes: 0

Related Questions