使用VBA替换Microsoft Project Professional 2010中的资源 [英] Replacing Resources in Microsoft Project Professional 2010 using VBA

问题描述

我想用编程方式使用VBA替换资源名称，使用MS Project Professional 2010中企业资源库上的任何可用资源。

我可以在MS Project中手动完成，方法是转到Resource选项卡，然后从Enterprise中选择Build Team打开Filter Enterprise Resources表单，其中包含：

我勾选资源名称复选框，选择"包含"从与其相邻的下拉框中，在其旁边的文本框中输入名称或名称的一部分，然后单击确定按钮以打开Project 1表单的构建团队（Project1是当前活动项目），
显示包含在Filter Enterprise Resources表单中输入的搜索字符串的所有资源名称。

我有一个带文本框的用户表单（供用户输入搜索字符串）和一个替换按钮（用户应该单击转到Build1 for Project1表单）。

我可以使用VBA打开Filter Enterprise Resources表单（ Appllication.EnterpriseTeamBuilder）但我不能以编程方式提供t他输入信息（勾选复选框，在组合框中设置搜索条件，在文本框中输入搜索字符串
并单击确定按钮），以便进入Build Team for Project1表单以查看资源列表。

如果你能帮我编写这个功能，我将不胜感激。

谢谢SRNms

解决方案

SRNms，

我不使用Project Server但这似乎是一个尝试录制你经历这个过程的宏的好地方然后查看生成的代码并将所需的语句合并到现有代码中。

只是想一想。

John

I would like to replace Resource name, programmatically using VBA, with any of the resources available on the Enterprise Resource Pool in MS Project Professional 2010.

I can do it manually in MS Project by going to the Resource tab, then selecting Build Team from Enterprise to open the Filter Enterprise Resources form, on which:

I tick Resource Name checkbox, select "contains" from the dropdown box adjacent to it, enter a name or part of a name in the textbox next to that and then click OK button to open the Build Team for Project1 form (Project1 is the current active project), which shows all the resource names containing the search string entered on the Filter Enterprise Resources form.

I have a userform with a textbox (For the user to enter the search string) and a Replace button (the user should click to go to the Build Team for Project1 form).

I can open the Filter Enterprise Resources form using VBA (Appllication.EnterpriseTeamBuilder) but i can't programmatically provide the information (ticking the checkbox, setting the search criterion in the combobox, entering the search string in the textbox and clicking the OK button) in order to get to the Build Team for Project1 form to view the list of resources.

I would greatly appreciate it if you kindly help me with the coding of this functionality.

Thanks SRNms

解决方案

SRNms,

I don't use Project Server but this seems like it might be a good place to try recording a macro of you going through the process manually. Then look at the resulting code and incorporate the needed statements into your existing code.

Just a thought.

John

这篇关于使用VBA替换Microsoft Project Professional 2010中的资源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！