[spope]

My macro is designed to start when any file is added to folder x. My problem is that my macro needs to open the newly added file. The name will be different every time but it usually labeled in the format NDxxxxxx-xx-xxx (where x's are numbers). I can't figure this out...Is the file name a variable? If it is how do I make that work?

By opening the file in it's application, I can gather the numbers that I need and save them in a notebook format through my macro. Right now my macro is just opening the same file every time. I thought I might do it through windows explorer by sorting by the newest files in the folder by when they were created but it seems kind of sketchy.

It seems like this would be a common problem. I saw the thread by TheBrain but he doesn't say how he opens his file, only how it is triggered by creating a new file.

Thanks,
spope