BullZip Home

If the file name changes in some predictable way then you can build the directory and file name as a string in the macro and then use that string with Workbook.Open if its an Excel file or OpenTextFile if not. If you want to have the user select files, then take a look at FileDialog. [img]http://fot...