Forum Discussion
Original copy of Excel office VBA
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.
- Yeah brother... you helped me much , thanks 🙏
One more time, general question about Microsoft office excel :
If someone using an original version of office ( original = active version) and original version of OS win10 as example, so .. sure the VBA that I created should work well without mistakes, right?
I asked this question .. to make sure before buying activations for win10 and office because they are too expensive in my country, so I wanted to make sure before buy .. okay?The Excel (office version) that the operating system uses is Excel Online or Excel for web.
So where I mention Excel for web is the free version that Windows has available without first having bought a subscription version (subscription version like Office 365) or desktop version (like Excel 2016, 2013).
While it's not a thorough explanation, I think this rough explanation might help you.
Thank you for you all understanding and patience
I know I don't know anything (Socrates)
- Thanks brother, it's office for desk top ... like 2013 and 2016 version