I have a source data file that is system generated every day so the last few "File_Name_68992372.xls". I have found some code on this forum to find the file and rename it to a predefined name, but I want the user to be able to specify where it gets saved so I need a save as dialog. I also want the file to be in .xlsm format.

Thanks

Please Login or Register  to view this content.