VBA - Export Resource Usage in to a list.

[stuart block]

Can anyone please help me.

I am using Project 2000.

My situation is that I control between 50 and 100 projects in a MasterProject.

Management want to be able to see information for resource level or project
level.

What I want is a vba macro that will export the resource usage in list for
use in Excel, eg.

Project Name : Resource Name : Wk Start : Hours : Cost

Project1 : John Smith : 04june2005 : 36 : 360
Project1 : John Smith : 11june2005 : 36 : 360

etc.

So that I can generate query's / report to give management the information
that they require.

Thanks
Stuart

 

[Ed Morrison]

Stuart,
An easy way to export data from a database into Excel is to use the Import
External Data wizard under the Data menu in Excel. Put the SQL code I gave
you in the previous post. Your users only have to click on Refresh Data to
update the report (or it can automatically update every time they open the
spreadsheet). No VBA required.

 

[stuart block]

Ed, I known how to transfer data from a database in to excel.

What I need is an easy way to get the resource data from Project 2000 in to
a list as previous described.

Your SQL code, doesn't work with the software that I have, and I don't know
anything about SQL, to even attempt to play with it.

The project files are all separate, rolling up to a master project. The boss
doesn't want me to convert them all in to a database.
So that is why I really need to export project data via a VBA in to the list
below.

I would love to get the company to upgrade to Project 2003, and utilise
project server, but they won't spend out.