Opening a Project File from Project Server Using a Direct Link or Excel VBA RRS feed

  • Question

  • I have a bunch of graphs/displays that I have created in an Excel file that is pulling data from a Project file. The current Project file is stored on a shared drive. We are in discussion about going to a Project Server and I'm trying to figure out if it is doable to pull from the Project Server, open in Project Professional, and pull the data that I need.

    I think my two options are:

    1) A link that will directly open the Project File in Project Professional (I know this can be done with Sharepoint, but I can't figure out if it's doable on Project Server)
    2) Some sort of VBA code that can open Project Server and open the file in Project Professional

    I've played around a bit with both options and have come up empty. Any help would be greatly appreciated!!

    Wednesday, July 8, 2015 2:43 PM