Word Macro

[Rich]

Hi all
I have been asked to produce a macro that will take a word document from
a specific location open it, print it and delete.

Sounds easy, but the problem I have is that the name of the document(s) in
the specific location will not be known. I think the best approach would
be to loop though the files in the directory, print them all out and delete
them one by one. Is this possible?

Also the macro will need to work every five minutes or so is there a way
of leaving word open and having the macro run every 5 minutes without someone
starting it?

Any help on these matters will be much appreciated.
Rich

[Paul Clement]

On 11 Sep 2001 06:12:44 -0700, "Rich" <Richard.Bowen@logobrand.com> wrote:

¤
¤ Hi all
¤ I have been asked to produce a macro that will take a word document from
¤ a specific location open it, print it and delete.
¤
¤ Sounds easy, but the problem I have is that the name of the document(s) in
¤ the specific location will not be known. I think the best approach would
¤ be to loop though the files in the directory, print them all out and delete
¤ them one by one. Is this possible?

Yes, you can use the Dir function to iterate through the files in a specific folder.

¤
¤ Also the macro will need to work every five minutes or so is there a way
¤ of leaving word open and having the macro run every 5 minutes without someone
¤ starting it?

Take a look at the Controls section at http://www.mvps.org/vb/. There should be a Timer component
you can use to do this.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)