Visual Basic

Hey there!
I wanted to make a Visual basic program to open all the files in a directory (C:\CNS) - which will contain word files.

I need these to be opened one by one,

A macro to be run on them --> Save the changes in a new file --> delete the old file --> open the next file in the directory.
I've written most of the program just need to know how i can open the next file in the directory continuosly until there are no files left!!

Please help if you can
tanx

 

You could probably manage what you're doing by looping through all the files in the File System Object.

 

And how do i do that?