Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 17-09-2009
Member
 
Join Date: Sep 2009
Posts: 177
Compatibility issue with Excel 2007 VBA

With the previous version of Office, i.e. OFFICE 2003, we used to have an application. It was working properly before but after upgrading to Office 2007, the application fails to launch any more saying an error in VBA. I called my application developer but the person is not able to identify the problem. Is this the compatibility issue with Excel 2007 VBA?
Reply With Quote
  #2  
Old 17-09-2009
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: Compatibility issue with Excel 2007 VBA

The different versions of Excel always generate problems of compatibility with VBA. This actually comes from the change of reference (in Visual Basic Editor, Menu Tools>> References). You mark the references active in the 2003 versions and throw them back in order, under the 2007 version.
Reply With Quote
  #3  
Old 17-09-2009
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Compatibility issue with Excel 2007 VBA

The application is not consistent with 2007 may be because it is written in C and thus impossible to see the macros. I am afraid that the application can be used with Office 2007 or require the entire recast of it.
Reply With Quote
  #4  
Old 18-09-2009
Member
 
Join Date: May 2008
Posts: 685
Re: Compatibility issue with Excel 2007 VBA

Office 2007 introduces a new feature called compatibility mode in which incompatible features such as the SmartArt diagramming tool won?t be available to you. In Office 2007, VBA features have been changed working code needs to be tweaked to run in 2007.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Compatibility issue with Excel 2007 VBA"
Thread Thread Starter Forum Replies Last Post
How to turn off compatibility Checker in Microsoft Excel 2007 CeLeStiA MS Office Support 2 21-02-2012 02:20 PM
How to disable compatibility mode in Microsoft Excel 2007 AdilShaikh18 MS Office Support 4 24-01-2012 05:20 PM
Excel 2007 compatibility mode and Offline files and shared workbooks shivendra Windows Vista Network 2 16-11-2011 10:01 PM
How to check data validation compatibility of excel 2010 on excel 2007 Zoello Windows Software 6 17-05-2011 10:00 PM
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats Bob Server Update Service 5 17-01-2008 02:35 AM


All times are GMT +5.5. The time now is 05:39 AM.