I'm attempting to simply a process at work. Our "computer guy" has no idea how to do this. We have an .html file saved with the date as part of the file name and into a folder that is something like d/rdrive/archive/03232009 that has the date at the end. i'm wanting to be able to enter the date in a cell and have the macro open the specific folder and file. i have most of it down, i just need to know how to get into the folder based on cell input....thanks in advance for the help!