Hi, I have this macro that someone had helped me with quite a while ago. It was working fine until I went to update it to work for Excel 2007.
The macro below is what it was until I changed ".xls" to ".xlsx". 'SaveAsExcelWorkbook2() 'Remember to add the reference to Microsoft Scripting Runtime Dim TheFileName Dim fso As FileSystemObject Set fso = New FileSystemObject TheFileName = fso.GetBaseName(ActiveWorkbook.Name) & ".xls" TheFileName = Application.GetSaveAsFilename(TheFileName, _ FileFilter:="Microsoft Office Excel Workbook (*.xls),*.xls") If (TheFileName <> False) Then _ ActiveWorkbook.SaveAs Filename:=TheFileName, FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False Set fso = Nothing I also had another part of the macro that I had to change the number of rows to like 600K. Anyhow, the changes seem to work until the very end when I get a pop-up like the following: "Compatibility Report for NON POC-FIX.xlsx Run on 8/11/2010 17:42 The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format. Significant loss of functionality # of occurrences This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error." Anyhow, I'd like to figure out what is causing the pop-up for compatibility to show up and figure out why the file that is being created now is corrupt and won't open. Thanks, Steve -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
