Solved

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

Posted on 2014-04-21
1
382 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 350 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 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