Matlab not accessing microsoft project applications
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Ashleen Hayes
el 6 de Feb. de 2017
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 comentarios
Guillaume
el 6 de Feb. de 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');
Respuesta aceptada
Guillaume
el 7 de Feb. de 2017
Editada: Guillaume
el 7 de Feb. de 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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Project File Management en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!