Matlab not accessing microsoft project applications
2 views (last 30 days)
Show older comments
I am trying to access MS Project from Matlab to create a .mpp file and no matter what I try, I always get the same error:
Edit:
Undefined function or variable 'Projects'.
Error in Project_Testing (line 45) invoke(project.Projects,'Add');
I currently have the following code:
project = actxserver('MSProject.Application');
set(project,'Visible',1);
invoke(project.Projects,'Add');
invoke(project,'FileSaveAs','NewProject.mpp');
I am getting the error on project.Projects and I have also tried doing another invoke to get .Projects but nothing I have tried has worked
3 Comments
Guillaume
on 6 Feb 2017
I don't have MS Projects installed on this machine, so can't test anything, but at first glance your code looks OK. Have you tried looking up the error code you get (and what is it anyway?)
Note that you don't need to use set and invoke, the following would work (or not work) just as well:
project = actxserver('MSProject.Application);
project.Visible = 1;
newproj = project.Projects.Add;
project.FileSaveAs('NewProject.mpp');
Note that for the last line, I'd use the SaveAs method of the project you've created instead:
newproj.SaveAs('NewProject.mpp');
Accepted Answer
Guillaume
on 7 Feb 2017
Edited: Guillaume
on 7 Feb 2017
After testing on a computer with MS project installed, it would appear that matlab does not 'see' the interface methods, properties, etc. so indeed you have to use get, set and invoke. Therefore, you can't use project.Projects, you have to get the Projects collection:
msproj = actxserver('MSProject.Application');
set(msproj, 'Visible', true);
projects = get(msproj, 'Projects');
newproj = invoke(projects, 'Add');
invoke(newproj, 'SaveAs', 'NewProject.mpp');
%...
invoke(msproj, 'Quit');
Maybe Steven Lord or somebody else from Mathworks will explain why matlab fails to see the interface properly ( methodsview only shows the standard matlab methods) yet still works with invoke.
0 Comments
More Answers (0)
See Also
Categories
Find more on Project File Management in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!