Forum Discussion
Add, Edit, Delete Project Online data using Excel
- Sep 17, 2019
Hello MonteStJohns,
You could probably automate this import if you have consistent source data across all the Excel files but this would be custom code - potentially VBA / VSTO add-in for Excel / Project. Out of the box you do have the ability to import Excel data to Project too https://support.office.com/en-us/article/import-excel-data-into-project-cb3fb91a-ad05-4506-b0af-8aa8b2247119
Paul
Thanks for your prompt reply.
At this time - I'm in the embryonic stage of trying to use PWA/PO for initially Portfolio Management - with first focus on Resource Management and Portfolio Prioritization. We don't even have enough licenses NOR have we trained PMs to use any MS Project suite of tools.
So first thing I'm trying to do - is get the "single-source" of data out from 100's of separate XLS files into PWA/PO. So, me and my first EPPM team member are doing ALL the work by ourselves - and it will be that way for at least the next 90-120 days as we first have to SELL the approach, then assuming it works, then we have licensing, training etc until we're at the point we're 30-45 individuals are creating/maintaining the content.
Here's a link (https://www.xappex.com/#/Enabler4Excel) to the tool I've used in my past to do similar work at different organization when we were using SFDC as the primary development platform for many business process (including EPPM).
I'll be at the office in an hour or so and will look closely at the links you provided.
As always, appreciate your prompt/candid feedback.
Monte
Hello MonteStJohns,
You could probably automate this import if you have consistent source data across all the Excel files but this would be custom code - potentially VBA / VSTO add-in for Excel / Project. Out of the box you do have the ability to import Excel data to Project too https://support.office.com/en-us/article/import-excel-data-into-project-cb3fb91a-ad05-4506-b0af-8aa8b2247119
Paul
- MonteStJohnsSep 17, 2019Copper ContributorAny chance we can arrange a quick chat? If so, please offer some times (mstjohns@gcpud.org) -? I’m in US PST.
- Paul_MatherSep 17, 2019MVP
Hello MonteStJohns,
Unfortunately the only support I can offer is via this thread. You can reach out to one of the Microsoft Project Partners for consultancy etc. I work for a partner called CPS (CORPORATE PROJECT SOLUTIONS LIMITED) but you can find a partner here if required: https://www.microsoft.com/en-gb/solution-providers/home
Many thanks
Paul