Exporting Data

[CK]

Dear All,

I am new into Macros and Programming and I would like to help me on creating
a macro or VB code on how to export certain data into a specific structure in
Excel. Also, if there is a possibility to do that from multiple Project
files into one spreadsheet.

Thanx a lot

 

[John]

Dear All,

I am new into Macros and Programming and I would like to help me on creating
a macro or VB code on how to export certain data into a specific structure in
Excel. Also, if there is a possibility to do that from multiple Project
files into one spreadsheet.

Thanx a lot

CK,
If you want to learn VBA for Project, go the the MVP website at:
http://www.mvps.org/project/links.htm
At the bottom of the page you will see a link to, "Project 98 Visual
Basic Environment Training Materials". Even though it says it is for
Project 98, it is equally applicable to all current versions of Project.

If you would like to see some sample VBA macros, check out fellow MVP
Jack Dahlgren's website at:
http://www.mvps.org/project/links.htm

To answer your question, yes, it is possible to export data from
multiple Project files into a single Excel Worksheet.

Hope this helps.
John
Project MVP

 

[CK]

Thanks John,

I found the links and the example very good. I need to work on my VB to
modify the code to include the rest of the columns and not just the Tasks.
Also, to include more than one project into the same workbook.

Any hints/tips?

 

[John]

Thanks John,

I found the links and the example very good. I need to work on my VB to
modify the code to include the rest of the columns and not just the Tasks.
Also, to include more than one project into the same workbook.

Any hints/tips?

CK,
When you say, ". . . modify the code. . .", what code are you referring
to?

As far as including multiple projects into the same Worksheet there are
probably as many approaches as there are users writing the macro code.
For example, one approach has the VBA code residing in Excel. The code
then sequentially gets the data from each Project file and imports it.
The code could also reside in a dummy file (or one of the files to be
exported) in Project and the data could be exported from there to a
common Excel Worksheet. A third approach is to have the code reside in a
separate VB macro (this requires a standalone version of VB). And a
fourth approach might be to do some type os SQL query. I've never worked
with SQL so I can't help with that.

As you can see there are many possibilities. It all depends on your
level of knowledge and preference.

Learning VBA is not an overnight thing. If you are just starting out,
you need to read the tutorial material, study the examples and then
write some macros to exercise what you have learned. If you just can't
wait to progress through the learning cycle, you can always hire someone
to write the code for you.

Hope this helps.
John
Project MVP

 

[MSPLearner]

Jack Dahlgren's code exportcode maintains the Summary task hierarchy which
has it's own uses. However, is there any code that let's me simply write one
row per (non-summary) task choosing specifc custom fields. I am a complete
VBA novice and just started learning it's value.

Thanks in advance.

 

[John]

Jack Dahlgren's code exportcode maintains the Summary task hierarchy which
has it's own uses. However, is there any code that let's me simply write one
row per (non-summary) task choosing specifc custom fields. I am a complete
VBA novice and just started learning it's value.

Thanks in advance.

MSPLearner,
If you want to learn VBA in more detail, I suggest you get fellow MVP,
Rod Gill's book, "VBA Programming for Microsoft Office Project". You can
find out more about it and also about Rod's on-line VBA training classes
at,
http://www.projectvbabook.com
and
http://projectservertraining.com/learning/index.aspx

A few years ago I wrote a simple macro for exporting Project's Notes
field to Excel. I've provided it to many users such as yourself. It is
similar to Jack's macro but does not concern itself with maintaining the
outline structure. It would be very easy to modify to export whatever
Project fields you want. It you want to know more about it, contact me
direct. My address is below.

John
Project MVP
jensenj6atatcomcastdotdotnet
(remove obvious redundancies)