Using VBA in Excel, how do I trigger a list of TIF files located in different folders on server to play one after another in MS Picture Viewer?
Posted on 2013-01-31
In an Excel spreadsheet, I have a short list of TIF files (filenames & server location paths), each of which is its own folder on a server. Via a VBA macro hooked up to a user button that says "Play / View All Files In A Sequence", I need to trigger this list to play the TIF files in MS Picture Viewer (probably using a hyperlink field that is dynamic and looks at each file name), one after the other, though they are in separate folders on the server and have to remain in those separate folders.
I am not sure how to write this code to make this work, but I suspect that it has something to do with a For Next loop.
This is a real challenge! Thank you for your time and help!!