adding resources to the resource sheet in ms project using vba
I have created a form with combo boxes that are populated
from three small Access tables. I am trying to populate
certain fields within an MS Project Resource sheet based
upon the values that are selected from the combo boxes. I
get a run-time error because there are no previous values
in any of the fields within the rows that I am trying to
populate in the resource sheet. Is there anyway to add
info to fields within the resource sheet using
VBA code? I
do not wish to import data into the resource sheet using a
map. This is a sample similar to the code I have written:
Count = ThisProject.Resources.Count
Call InsertResource
Count = Count + 1
ThisProject.Resources.Item(Count).StandardRate = TOTAL
Where InsertResource is a Macro to insert a new resource
that looks something like this:
ViewApply Name:="Resource Sheet"
SelectRow Row:=1
And where TOTAL is variable storing a formula derived from
values within the access db based upon the combo box
selections.
Any ideas on how to insert an entirely new resource into
the resource sheet (if there are no values in any of the
fields for the row to be inserted) would be greatly
appreciated.
Thanks!
Beth
