I get a lot of .xls files from generated reports. I have to go through the Save As dialog every time to save them as .xlsx.

The path is not always the same, nor is the file name. So what I need is a general macro for my background macro workbook that parses the file path, file name, then saves the file as .xlsx with the same name and path. I'm a little stumped on this one! Thanks!