Forum Discussion
Solved
Excel macro to help transfer projects from Wrike to MS Project?
Hi all,
I am in the process of transferring projects from Wrike to Project via excel Wrike-export files.
The structure of the Wrike exports into Excel do not match what Project expects.
I was wondering whether anybody knows of or has a macro of sorts that helps modify the Excel Wrike export files to improve importing them into Project.
Best,
Jacques
- Jacques,
I've written a few macros that transfer data from Excel to Project but I've never heard of Wrike. When you say the Wrike exports do not match what Project expects, what exactly do you mean?
If you are attempting to use an import map from Excel to Project, it's a matter of setting up the import map. However, if transferring the data with VBA, its just a matter of reading the data in Excel and putting it into Project in the correct form.
John
6 Replies
- Jacques,
I've written a few macros that transfer data from Excel to Project but I've never heard of Wrike. When you say the Wrike exports do not match what Project expects, what exactly do you mean?
If you are attempting to use an import map from Excel to Project, it's a matter of setting up the import map. However, if transferring the data with VBA, its just a matter of reading the data in Excel and putting it into Project in the correct form.
JohnJohn-project , Hi John, your prompt answer is much appreciated.
What I meant it that the Wrike export map in Excel does not match what Project needs for a clean import.
Wrike is a project planning tool that can do gantt charts, resource allocations, etc., dependencies, task, projects, folders hierarchy, i.e. most of what Project can do.
Hoping that clarifies maters,
Best, J.- Jacques,
You're welcome and thanks for the feedback.
I'm not sure what you are expecting for a "clean import". In my mind, a "clean import" of Excel data into Project is a matter of setting up the correct parameters (i.e. field matching), and merge key if applicable, in the import map.
There are basically three ways to get Excel data into Project - copy and paste, import map via the Import Wizard (File > Open > Excel Workbook.*xlsx), or VBA.
John
