Jul 24 2020 02:11 PM
Hello:
I have a client whose Excel applications are all using the online version. The current project requires VBA. It appears that VBA is not available in the online version.
Can I create a desktop version and somehow have the results uploaded to the client's Office 365 One Drive. Will it strip out the VBA if I can upload it?
How is the interchange between VBA enabled desktop and Online Excel happen?
Thanks,
Jul 25 2020 10:06 PM
Hey @richlocusoutlookcom ,
The macros should stay intact, though you can't run them in excel online but you can very well create a file using desktop app and upload it.
Jul 26 2020 11:16 AM - edited Jul 26 2020 11:16 AM
The online "alternative" (likely won't replace the VBA you need) is Office Scripts which do run in the browser - https://docs.microsoft.com/office/dev/scripts/develop/scripting-fundamentals.