I need some suggestions on how to accomplish this. I want to be able to process all files that are put in a folder one by one until there are no more files in the folder. In other words, users are putting files in a folder and I want to be able to run a macro on each file (open the file, convert to HTML, etc- this part is done) in the folder, delete the file that I just processed and go on to the next one if there are any more files.
I can run the macro at certain intervals but I don't know how to tell it to check and see if there any files in that folder and then open that file with any program (Word, IE, etc.).
Any suggestions are appreciated.
Thank you, Raul