| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving as .xlsx from VBA MACRO
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set default Excel Saveas file format to xlsx not xlsx | Setting up and Configuration of Excel | |||
| Macro For Saving As .txt | Excel Discussion (Misc queries) | |||
| Saving Macro | Excel Discussion (Misc queries) | |||
| Help with saving a Macro | Excel Worksheet Functions | |||
| saving xlsx file as xls changes currency symbols | Setting up and Configuration of Excel | |||
Threaded Mode
