Solved

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

Posted on 2014-04-21
1
385 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

751 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