Writing out to a TXT or CSV file

[JJ]

I need to write out Project values to a TXT or CSV file without the
use of an Export Map. The reason being is the following:

I have a standard Export Map that was given to me to create a CSV
file. One of the fields (say Text25) on the Export Map is reserved for
a particular group or people and there is no changing that. However,
this means Text25 is locked out from use by everyone who uses the
Export Map. So, I thought that I could create the CSV file using VBA
to create the same results as the Export Map, BUT create a blank entry
for Text25 in the position it would be in the CSV file. This would
allow all of the users to use Text25 without including it in the CSV
file.

Also, I COULD change the Export Map such that another Text field is
substituted for Text25, but there is no guarantee that whatever Text
field I choose is ALWAYS going to be empty. Therefore, I have decided
not to pursue this option.

Thanks in advance!
JJ

 

[Jack Dahlgren]

I have some code for this here:

http://zo-d.com/blog/archives/programming/vba-writing-to-a-text-file-ms-project-excel.html

You can easily loop through all the tasks and write out whatever you want.

More about looping through tasks etc. can be found here:
http://zo-d.com/blog/archives/programming.html

-Jack Dahlgren