Solved

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

Posted on 2014-04-21
1
372 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 18

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now