Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 02-02-2016, 04:05 PM
macropod's Avatar
macropod macropod is offline Save as File for Excel 2010 Windows 7 64bit Save as File for Excel 2010 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,234
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #3  
Old 02-03-2016, 07:10 AM
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
Smile Excellent!!!

That worked. Thank you so much for this. Really appreciated.
Reply With Quote
Reply

Thread Tools
Display Modes


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 06:24 PM.


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