R
richspkl
Having spent a few days wrestling with this I thought I'd share my progress
and check if anyone has anything to add.
My aim is to integrate MS Project (2003 or 2007) functionality into a vb.net
(VS2005) application, ideally with the full MS Project functionality.
Initially I programmatically loaded up a 2007 Project file and fired it up
in a native MS Project standalone application which wasn't too difficult to
do from a vb app.
(for a good example:
http://www.codeproject.com/KB/aspnet/MS_project_and_Aspnet.aspx)
Next our client thought it would be preferable to have the Gantt chart view
that he was after displayed with a windows form (just like we’ve done with
excel previously).
Meeting this requirement has proven a little problematic as we’re yet to
find a satisfactory solution.
Forums have suggested a few different approaches for embedding office suite
applications, however all appear to suffer from the same shortfall in active
x control completeness (or at least that’s my summation). They do all indeed
provide the capability to load up mpp files, although the Project
functionality is only partially supported.
Controls are of very limited (basic) use, settings on any new control form
are unchangeable (try to adjust the timescales for example)
Solution tested (VS 2005 MS Project 2007)
WebBrowser (uses IE) http://support.microsoft.com/kb/243058/
dsoFramer –(Active X) (same issue)
http://blogs.msdn.com/erikaehrli/archive/2005/08/26/hostofficeinnet.aspx
Proprietary solution - www.ocxt.com (same issue)
OfficeWebComponents – no Project view options that I’m aware of.
Also tested dsoFramer on VS2008 and MS Project 2003 (similar although
slightly better functionality – check boxes appeared to work)
Interestingly (or frustratingly) enough when you run up the C++ sample
supplied with the dsoFramer
http://support.microsoft.com/default.aspx?scid=kb;en-us;311765 all the
controls seem to function as expected – but now the application layout and
how to transition this to a VB application is now a bigger problem.
Suggestions most welcome.
and check if anyone has anything to add.
My aim is to integrate MS Project (2003 or 2007) functionality into a vb.net
(VS2005) application, ideally with the full MS Project functionality.
Initially I programmatically loaded up a 2007 Project file and fired it up
in a native MS Project standalone application which wasn't too difficult to
do from a vb app.
(for a good example:
http://www.codeproject.com/KB/aspnet/MS_project_and_Aspnet.aspx)
Next our client thought it would be preferable to have the Gantt chart view
that he was after displayed with a windows form (just like we’ve done with
excel previously).
Meeting this requirement has proven a little problematic as we’re yet to
find a satisfactory solution.
Forums have suggested a few different approaches for embedding office suite
applications, however all appear to suffer from the same shortfall in active
x control completeness (or at least that’s my summation). They do all indeed
provide the capability to load up mpp files, although the Project
functionality is only partially supported.
Controls are of very limited (basic) use, settings on any new control form
are unchangeable (try to adjust the timescales for example)
Solution tested (VS 2005 MS Project 2007)
WebBrowser (uses IE) http://support.microsoft.com/kb/243058/
dsoFramer –(Active X) (same issue)
http://blogs.msdn.com/erikaehrli/archive/2005/08/26/hostofficeinnet.aspx
Proprietary solution - www.ocxt.com (same issue)
OfficeWebComponents – no Project view options that I’m aware of.
Also tested dsoFramer on VS2008 and MS Project 2003 (similar although
slightly better functionality – check boxes appeared to work)
Interestingly (or frustratingly) enough when you run up the C++ sample
supplied with the dsoFramer
http://support.microsoft.com/default.aspx?scid=kb;en-us;311765 all the
controls seem to function as expected – but now the application layout and
how to transition this to a VB application is now a bigger problem.
Suggestions most welcome.