Compatibility issues

vba Slovenia
  • 13 years ago


    I have a problem with an application I have made in VBA for Excel and hope you will be able to help me out.

    I have made a small database in Excel with user interface, which is shared between several users in our company.

    The problem is that not all users use the same version of MS Excel (Office) and some compatibility issues arise. I believe I use one of the latest versions of MS Excel available in the company. The problem arises when another user with an older version of Excel opens the application and saves the changes he or she has made (to the spreadsheet via user interface but not the VBA code). After that the application won’t run on my computer but still works on other computers which presumably use the same (older) version of software. I have also noticed that the file size reduces from 370 KB to 330 KB after the application has been opened and saved by another user with an older version of Excel.

    This doesn’t make much sense to me … I would understand if my application didn’t run on the older version of Excel but not the other way around as in my case. Is there a way to tell VBA not to save any changes to the VBA code which might have been done automatically during the compilation on another computer? That is, only changes to the spreadsheet should be saved.

    Is it possible to append certain libraries to the VBA code that would enable it to run on the older version of Excel without severely changing the code during compilation (I assume this might be the cause)?

    Any help or helpful suggestions will be appreciated!


  • 13 years ago

    We experienced the same problems on our ones...ammended the problem by using older computer to rewrite macro

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The greatest performance improvement of all is when a system goes from not-working to working.” - John Ousterhout