I've had to use this to save as an xlsm
ThisWorkbook.SaveAs Filename:=filesavename, _
FileFormat:=52
This should help you figure out what you need.
http://www.rondebruin.nl/saveas.htm
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"Donhuff" wrote:
I am attempting to save files through a MACRO as .xlsx files using
getclosefilename function. I have Excell 2007 set to save all files as .xls
files. When I save the files, it places the .xlsx extension, but saves in
.xls format. I cannot open the files as they are, but can after changing the
extension to .xls through Explorer they open just fine.
How do I set Excel 2007to save files as .xlsx through the MACR VBA?