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)
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