Excel with Microsoft Project object
Posted: Thu Dec 31, 2009 4:51 pm
Hello,
First of all Happy New Year to everybody...
But before going out to have fun for the new year party i would like to make you a qestion about the integration between Excel and Microsoft Project.
Any of you have ever had an experience in this kind of integration? if yes, do you know if there is a place where I can find this information (how to)?
What I would like is :
1) vith a VBA macro create and feed a Microsoft Project (a simple plan) with all valua, dates and so on stored in the Excel (I don't know maybe there is some Cognos API to do it )
2) Make a TI procedure that update the Cube where the Project changes his values
Thanks for your time and happy new year again
Nicola
First of all Happy New Year to everybody...
But before going out to have fun for the new year party i would like to make you a qestion about the integration between Excel and Microsoft Project.
Any of you have ever had an experience in this kind of integration? if yes, do you know if there is a place where I can find this information (how to)?
What I would like is :
1) vith a VBA macro create and feed a Microsoft Project (a simple plan) with all valua, dates and so on stored in the Excel (I don't know maybe there is some Cognos API to do it )
2) Make a TI procedure that update the Cube where the Project changes his values
Thanks for your time and happy new year again
Nicola