Create a publich module in your VBA project Same mapping I have put in the above code:ĭo not ask me why version number 13 is missing from the sequence 🙂 Each version of the excel can be determined by the following mapping of Version Number and name. VBA.Val(Application.Version) returns a number. Whenever you call the bellow function at any moment of time when it is necessary to check the version of the excel. It is a very simple piece of code which will determine which version of excel user is using. This way before processing the data if you can identify the version of the excel user is using then you will be able to handle the error without crashing the excel.Īs user I would always prefer a clear message stating that “this functionality is not available in so and so Excel version” rather than getting some weird Microsoft error message and messing up other functionalities as well. then it is possible to do so without any error as they have got 16000+ columns in it. But if user is using any higher version like Excel 2007 etc. For Example: If you have some sales data using more than 256 columns then if user is using Excel 2003, then it would not be possible as Excel 2003 has got only 256 columns. Usually while working on any of the VBA projects, it becomes important for me to first check the version of excel which user is using and based on that certain functionality of my tool may or may not work.
