Matlab not accessing microsoft project applications

2017 2 6
1 个回答
回答已采纳
更新时间：2017 2 7
4 次查看（30 天）

0 个投票

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 个评论
显示 1更早的评论 隐藏 1更早的评论

Steven Lord
Steven Lord 2017-2-6
That's not the full text of the error message. Please copy and paste the full message, all of the red text, into a comment on this Answer.
Guillaume
Guillaume 2017-2-6
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');
Ashleen Hayes
Ashleen Hayes 2017-2-7
using set and invoke were the only ways I could get anything to work without a similar error as above. Using your code, gave me a similar error as above but on the project.Visible = 1; line

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Guillaume
Guillaume 2017-2-7
编辑：Guillaume 2017-2-7

1 个投票

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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 File Operations 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by