VBA Macro for MSPP 2003

[Mike B]

I am wondering if it is possible to write a VBA Macro that will copy an
MSExcel Worksheet into MSPP2003. the Excel worksheet consists of a combined
estimate sheet from four different departments with in our company. The four
different departments are totalized so only one column of estimated hurs will
have to be read/copied, however, (this is the real crux of the problem), when
osting to our standard MSPP template the hours must be distributed by
perctentage of total hours and probably up to a maximum of 7 different
resource types for each task. I plan on using some generic resource place
holders, once the plan is prepared I will assign resources from our
Enterprise Resource Database. Will this be possible to using VBA?

I appreciate any help or suggestions.

Thank you,

Mike B

 

[John]

I am wondering if it is possible to write a VBA Macro that will copy an
MSExcel Worksheet into MSPP2003. the Excel worksheet consists of a combined
estimate sheet from four different departments with in our company. The four
different departments are totalized so only one column of estimated hurs will
have to be read/copied, however, (this is the real crux of the problem), when
osting to our standard MSPP template the hours must be distributed by
perctentage of total hours and probably up to a maximum of 7 different
resource types for each task. I plan on using some generic resource place
holders, once the plan is prepared I will assign resources from our
Enterprise Resource Database. Will this be possible to using VBA?

I appreciate any help or suggestions.

Thank you,

Mike B

Mike,
Yes, most certainly, but have you looked into using an import map from
Excel to Project? Depending on how the Excel worksheet is set up, it may
be possible to import the bulk of the data and then hand massage as
necessary once that data is in Project. Take a look at the Project help
file on importing. If that doesn't work or is too involved, then I'd say
VBA is the way to go.

John
Project MVP

 

[Mike B]

Hi John!

Thank you for your quick response. I did look at the Mapping originally,
however it seemed like there is a lot of massaging I would have to do and I
am trying to get it to the point of minimum manual efffort. No matter what I
do, I know I will have to still do some manual work. Thank you again for you
help, I appreciate it.

Thank you,

Mike B

 

[JackD]

Yes it would be possible, but it will be a bit trick parsing all that data
out into multiple resource assignments.
If you are just asking if it is possible, the answer is yes, however, the
fact that you are asking the question indicates that you have a lot of study
ahead of you before you are able to do it.

 

[John]

Hi John!

Thank you for your quick response. I did look at the Mapping originally,
however it seemed like there is a lot of massaging I would have to do and I
am trying to get it to the point of minimum manual efffort. No matter what I
do, I know I will have to still do some manual work. Thank you again for you
help, I appreciate it.

Thank you,

Mike B

Mike,
You're welcome.

John