I am trying to write a macro that will open all the files sequentially in a
folder. For example, I have a folder with 30 files, and I want them to be
opened one after another. However, I do not want the specific filename to be
designated in the macro. Rather, I would like something that will simply
open the next file in the folder so that I can run the macro for multiple
folders. Does anyone have any suggestions?