Creating Save As / Open As Dialog Boxes for txt files using Project / VBA

[Red]

Hi -

I'm running two macros off a Project schedule saved in MS Project
Server. The macros allow me to pass tasks to and from another
application. One of the macros was originally written to save a txt
file with selected information from the MS Project schedule in the same



directory as the MS Project schedule itself. And the other macro was
written to find a txt file (with a predetermined name) in the same
directory as the MS Project schedule that the other application
exported.


I can run this fine if I create the schedule locally (i.e. on my
desktop). The problem is when I save the file in Server, the macro
doesn't know how to get the path off of it. To solve this I wanted to
have the macro pop up the Save As dialog box to save a text file (not
the project file) for some output. Same thing for the second macro to
find the text file (Open As dialog box).


Does anyone have any code snippets for Save As and Open As for a MS
Project macro?


Thanks -
Red

 

[Rod Gill]

To do this in Project you need to use Windows APIs. These are hard but good
news. You can get working code from:
http://www.mvps.org/access/api/api0001.htm

These work well. Alternatively, a simple class for reading and writing text
files is in my Project VBA book!

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Shane]

Rod - I have your book. I found the class that shows how to read a text file.
Where is the code that shows how to write to a text file? In fact, I need to
know how to create a blank text file, write to it, read from it, then delete
it. I'm sure that by the time I finish your book, I'll know how. But right
now I'm in Mod 9 and have this problem to solve now.

Thx,
Shane

 

[Jack Dahlgren]

Try this example:
http://zo-d.com/blog/archives/progr...ing-writing-project-properties-to-a-file.html

Note that using Write will write with quotation marks around each string.
This may make it easier to parse the string later - or not...
If you want text without the quotation marks you can use Print instead.

-Jack Dahlgren

 

[Shane]

Thanks, Jack, I'll give this a try.

Try this example:
http://zo-d.com/blog/archives/progr...ing-writing-project-properties-to-a-file.html

Note that using Write will write with quotation marks around each string.
This may make it easier to parse the string later - or not...
If you want text without the quotation marks you can use Print instead.

-Jack Dahlgren