Forum Discussion
Original copy of Excel office VBA
Hi guys, I create applications of VBA and sell for customers.. but my customers suffer with many many problems of excel versions!!! For example: the shortcut icon of VBA suddenly disappear from the desktop!!! , during the users work .. suddenly the VBA is sign out !!!
So, If I got an original copy.. will I avoid these problems? Can you please tell me what to do generally to avoid any breaking of these types to keep The VBA working well.. please 🙏
If your files are opened by customers with Excel for web, Sharepoint Online, or their own network with administrator-specific settings, problems will certainly arise. Example when opening the file with Excel online in Sharepoint, all VBA active X elements are not displayed or are removed when the file is opened.
For the time being, I can only recommend that you always follow the formula comparability and implement it in accordance with the Excel versions of your customers, which is not easy, but I do not know of any other way so far, so that you can edit a workbook in all Excel versions be able.
I could recommend third-party software as a detour and convert the workbook into an .exe file each time, so the customers could edit the file with the integrated Excel four, that's the theory...haven't tried it until now.
Maybe someone else knows a better trick.
Additional info/links:
Use Excel with earlier versions of Excel
Save an Excel workbook for compatibility with earlier versions of Excel
Compare two versions of a workbook by using Spreadsheet Compare
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
6 Replies
If your files are opened by customers with Excel for web, Sharepoint Online, or their own network with administrator-specific settings, problems will certainly arise. Example when opening the file with Excel online in Sharepoint, all VBA active X elements are not displayed or are removed when the file is opened.
For the time being, I can only recommend that you always follow the formula comparability and implement it in accordance with the Excel versions of your customers, which is not easy, but I do not know of any other way so far, so that you can edit a workbook in all Excel versions be able.
I could recommend third-party software as a detour and convert the workbook into an .exe file each time, so the customers could edit the file with the integrated Excel four, that's the theory...haven't tried it until now.
Maybe someone else knows a better trick.
Additional info/links:
Use Excel with earlier versions of Excel
Save an Excel workbook for compatibility with earlier versions of Excel
Compare two versions of a workbook by using Spreadsheet Compare
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Bro , thanks a lot for your answer 🙏
Im using Microsoftoffice-excel VBA.
My exact question : from your experience, if I got an original copy of Microsoftoffice-excel .. will my application work well without problems ? even the windows 10( as a example) was not original?
In other meaning.. if office was original and the windows10 was not original .. will I beat all VBA problems ?
Second case : to beat all the problems too , should the office be original and also the windows 10 should be original too ?I am not sure exactly what you mean by "original", but first I recommend only using original software...if that is what you mean :).
The compatibility differences are mainly between the differences between the Excel versions.
As for the operating system, there may be compatibility issues with some commands between Windows and Mac, but it should not really be an issue between the Windows versions.
Example: Older Excel versions do not recognize the new commands and VBA libraries, which can lead to conflicts.
Newer Excel versions, depending on the age of the Excel workbook, may not work completely without conflicts, especially when it comes to the number of rows and columns, as these differ in number.
Hope I could help you with that.
