Currently I open an xls file and must convert to xlsx then close and reopen the file in order for macros to complete.
The macros run fine after the conversion. I would just like to simplify the task since it is just going to others to manage in my absence.
With multiple files open what code can I use to select the xls open file and convert it to xlsx and then be able to continue in that file with the remaining macro?
As always - thanks in advance for your vba expertise.
Jim
Bookmarks