I have numerous occasions to save a copy of a workbook in a different file format (xlsX) and keep the main wb open (xlsM) using a macro.
ie
I have C:\FloorReport.xlsM open and finished posting data.
Next, I want to save it as C:\FloorReport.xlsX while leaving
C:\FloorReport.xlsM open.
If I use SaveAs it simply saves the open wb to the desired new format (xlsX) and closes C:\FloorReport.xlsM
If I use SaveCopyAs, it will NOT save it in the NEW format.
ANY help would be appreciated.
Hope everyone had a great New Years dat!!
cliff
ie
I have C:\FloorReport.xlsM open and finished posting data.
Next, I want to save it as C:\FloorReport.xlsX while leaving
C:\FloorReport.xlsM open.
If I use SaveAs it simply saves the open wb to the desired new format (xlsX) and closes C:\FloorReport.xlsM
If I use SaveCopyAs, it will NOT save it in the NEW format.
ANY help would be appreciated.
Hope everyone had a great New Years dat!!
cliff