#1
|
|||
|
|||
Save as File for Excel 2010
I have been using a macro to save files in the xls format but I now need to update that macro to save the files as the xlsx format. Below is the current vba I'm using.
What do I change to get it to save in the xlsx format? Dim FName As String FName = Application.GetSaveAsFilename(FileFilter:="Excel 97-2003 Workbook (*.xls),*.xls") ActiveWorkbook.SaveAs Filename:=FName, FileFormat:=xlExcel8 |
#2
|
||||
|
||||
Try:
Dim FName As String FName = Application.GetSaveAsFilename(FileFilter:="Excel Workbook (*.xlsx), *.xlsx") ActiveWorkbook.SaveAs Filename:=FName, FileFormat:=xlOpenXMLWorkbook
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Excellent!!!
That worked. Thank you so much for this. Really appreciated.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Save as File for Excel 2010 | mbesspiata | Excel | 1 | 11-18-2015 08:52 AM |
Excel 2013, Problem with a shared file, takes long time to load and save and loads missing data | PStark | Excel | 0 | 12-04-2014 07:52 AM |
how to save versions of 2010 excel documents | atof3kids | Excel | 1 | 10-01-2014 12:34 AM |
excel 2010 not deleting tmp files on save/close | willbaker13 | Excel | 0 | 04-26-2012 05:08 PM |
Unable to File>Save As.. or Open in Word 2010, please help | BrokenComputer | Word | 0 | 03-07-2012 10:20 PM |