I am trying to force a workbook to save as .xlsx format from a .xlsm workbook with a macro enabled button.
In the vba code I force it as .xlsx but it still saves as xlsm?
when I run the code in the immediate window is sets the filename as
"X:\Gordonsville\STARLINGS GORDONSVILLE\Cumberland Turnover\2014 Daily Equipment Usage\(3-17-2014) Day Gorwood DAILY EQUIPMENT USAGE.xlsx"
but it still saves the file as
"X:\Gordonsville\STARLINGS GORDONSVILLE\Cumberland Turnover\2014 Daily Equipment Usage\(3-17-2014) Day Gorwood DAILY EQUIPMENT USAGE.xlsm"
whats going on here?
Any help apprecaited.
Thanks
JR
Bookmarks