0

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?

Vadim Kotov
  • 8,084
  • 8
  • 48
  • 62
Vince
  • 33
  • 1
  • 2
  • 6

1 Answers1

0

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)

LiriB
  • 814
  • 8
  • 12