Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-02-2016, 01:24 PM
mbesspiata mbesspiata is offline Save as File for Excel 2010 Windows 7 64bit Save as File for Excel 2010 Office 2010 64bit
Advanced Beginner
Save as File for Excel 2010
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Question 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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Save as File for Excel 2010 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
Save as File for Excel 2010 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft