[LF] A universal macro that saves a .xls file as .xlsx

[MCunningham]

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!

[patel45]

Please Login or Register  to view this content.

[MCunningham]

patel45: That didn't do anything. Going step-by-step, it skipped the whole "Do" section after the first line.

[MCunningham]

Figured it out. Simpler than I thought. This will work if the file extension is .xls. I imagine you'd want to use a find for the file name and amend the extension if you weren't simply adding an "X" and changing the file type.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[MCunningham]

Hmm, wasn't aware of the FullName property. Thanks!