Forum Discussion
Add, Edit, Delete Project Online data using Excel
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
Hello MonteStJohns
Copied my reply from TechNet:
It feels like you could be over engineering something here, what's the issue with project managers maintaining their project schedules in Microsoft Project / PWA? Depending on what difficulties your users are having, it might be easier to build an add-in for Microsoft Project using VBA and keep it all in Project as you then do not have any data syncing challenges https://docs.microsoft.com/en-us/office/vba/api/overview/project
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
- Any chance we can arrange a quick chat? If so, please offer some times (mstjohns@gcpud.org) -? I’m in US PST.
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