Basic help for new starter

[jimbo]

Hi

I understand VB but cant get to grips with Project VBA.

I need a macro which will run through each task in my project, read the
name into a variable and the start date, end date etc into other
variables that I can then export to a text file.

Can anyone help me, Im sure its really simple

Thanks

 

[Jan De Messemaeker]

Hi,

Dim Job as task
For each job in activeproject.tasks
if not job is nothing then
Var1=job.name
Var2=job.start

etcetera


end if
next job

 

[John]

Hi

I understand VB but cant get to grips with Project VBA.

I need a macro which will run through each task in my project, read the
name into a variable and the start date, end date etc into other
variables that I can then export to a text file.

Can anyone help me, Im sure its really simple

Thanks

jimbo,
I know you posted to the VBA newsgroup, (which by the way is destined to
be closed in favor of the newsgroup that replaces it, namely,
microsoft.public.project.developer), but have you thought about simply
saving the project file in text format? You can do that by going to:
File/Save As and then selecting "text(tab delimited)" in the "Save as
type" selection box at the bottom of the Save As window. When you hit
"Save", the export wizard will pop up and lead you through the steps to
map Project fields.

John
Project MVP