Is it possible using VBA to automate copying actual hours from onetask to another?

[andy.novak]

What I want to do is:

1. Within a project
2. Talley ACTUAL HOURS entered BY RESOURCE BY DAY for a GROUP OF
TASKS
3. Overlay the DAILY TOTAL FOR EACH RESOURCE on LINE ONE OF THE
PROJECT

This may sound strange, but there is a legitimate need. Many thanks
for any and all advice concerning this.

Thanks,
Andy Novak
UNT

 

[Rod Gill]

Yes. Module 19 in my book gives all the code you need. As it happens, Module
19 is one of the sample chapters you can view at:
http://msdn.microsoft.com/en-us/library/ee355231.aspx

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

What I want to do is:

1. Within a project
2. Talley ACTUAL HOURS entered BY RESOURCE BY DAY for a GROUP OF
TASKS
3. Overlay the DAILY TOTAL FOR EACH RESOURCE on LINE ONE OF THE
PROJECT

This may sound strange, but there is a legitimate need. Many thanks
for any and all advice concerning this.

Thanks,
Andy Novak
UNT

__________ Information from ESET Smart Security, version of virus
signature database 4849 (20100208) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4849 (20100208) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[andy.novak]

Yes. Module 19 in my book gives all the code you need. As it happens, Module
19 is one of the sample chapters you can view at:http://msdn.microsoft.com/en-us/library/ee355231.aspx

--

Rod Gill
Microsoft MVP for Project -http://www.project-systems.co.nz

Author of the only book on Project VBA, see:http://www.projectvbabook.com












__________ Information from ESET Smart Security, version of virus signature database 4849 (20100208) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Thanks Rod. Man I've used your book so many times. Well worth the
investment. An update coming for Project 2010 perhaps?

 

[Rod Gill]

Hi Andy,

I'm writing it now! Update to include 2010 features (of course) and a whole
section on creating add-ins with VSTO.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Thanks Rod. Man I've used your book so many times. Well worth the
investment. An update coming for Project 2010 perhaps?

__________ Information from ESET Smart Security, version of virus
signature database 4852 (20100209) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4852 (20100209) __________

The message was checked by ESET Smart Security.

http://www.eset.com