Save as File for Excel 2010

mbesspiata · #1 11-18-2015, 08:25 AM

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

NoSparks · #2 11-18-2015, 08:52 AM

Have a look at http://www.rondebruin.nl/win/s5/win001.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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