?
Solved

Prompt for incompatibility when saving 'xls" to 'xlsx'  - Excel 2003 to Excel 2010

Posted on 2014-04-21
1
Medium Priority
?
398 Views
Last Modified: 2016-02-13
Experts,

Ian creating spreadsheets in SAS which is still creating the spreadsheets as xls.  I have Excel 2010 on my machine now.  

I have a macro which is formatting the spreadsheets.  Each time it saves I get the "incompatible message" attached.  Is there someway to code in VB so the process keeps going without manual response or to eliminate the message?
0
Comment
Question by:morinia
1 Comment
 
LVL 19

Accepted Solution

by:
Raheman M. Abdul earned 1400 total points
ID: 40012593
use the following line in your VB code to tick off the compatibility checking during saving

ActiveWorkbook.CheckCompatibility = False
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question