|
|
#1
11-18-2015, 08:25 AM
|
|||
|
|||
Save as File for Excel 2010
I have macros where I can save a file as Excel 2007 but I need to update those mascros in vba to save the file as Excel 2010. Below is what I currently have.
Dim FName As String FName = Application.GetSaveAsFilename(FileFilter:="Excel 97-2003 Workbook (*.xls),*.xls") ActiveWorkbook.SaveAs Filename:=FName, FileFormat:=xlExcel8 How do I change this to make it save as Excel 2010, xlsx? thanks Mike 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 |
|
File 'Versions' in Excel 2010
|
keithg | Excel | 2 | 02-19-2011 07:44 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode