Hello,

I've been stumped on this problem for a while and I'm hoping someone out there can help me. Basically, I'm trying to open a file in Excel by connecting a data source from a text file. I want to open/refresh the data in excel anytime a file is saved in a particular folder. The tricky part of it all is that the file names are dynamic, so it's not the same file being opened each time.

For Example,

I may have a csv that is created in a "c:/csv" folder called 01-1-15.csv. I'd like to have this automatically open in excel once it is saved (so ideally excel would somehow be scanning this folder). Then if I save file 01-1-16.csv, Excel would refresh with this new data. Is this even possible?

Thanks in advance.

Ron