VBA and Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-1544682%22%20slang%3D%22en-US%22%3EVBA%20and%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544682%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20client%20whose%20Excel%20applications%20are%20all%20using%20the%20online%20version.%26nbsp%3B%20The%20current%20project%20requires%20VBA.%26nbsp%3B%20It%20appears%20that%20VBA%20is%20not%20available%20in%20the%20online%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20create%20a%20desktop%20version%20and%20somehow%20have%20the%20results%20uploaded%20to%20the%20client's%20Office%20365%20One%20Drive.%20Will%20it%20strip%20out%20the%20VBA%20if%20I%20can%20upload%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20is%20the%20interchange%20between%20VBA%20enabled%20desktop%20and%20Online%20Excel%20happen%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1544682%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546208%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20and%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546208%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725464%22%20target%3D%22_blank%22%3E%40richlocusoutlookcom%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20macros%20should%20stay%20intact%2C%20though%20you%20can't%20run%20them%20in%20excel%20online%20but%20you%20can%20very%20well%20create%20a%20file%20using%20desktop%20app%20and%20upload%20it.%3C%2FP%3E%3CP%3ERef%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwork-with-vba-macros-in-excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwork-with-vba-macros-in-excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546735%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20and%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546735%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20online%20%22alternative%22%20(likely%20won't%20replace%20the%20VBA%20you%20need)%20is%20Office%20Scripts%20which%20do%20run%20in%20the%20browser%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Foffice%2Fdev%2Fscripts%2Fdevelop%2Fscripting-fundamentals%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Foffice%2Fdev%2Fscripts%2Fdevelop%2Fscripting-fundamentals%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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,

2 Replies

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.

Ref : https://support.microsoft.com/en-us/office/work-with-vba-macros-in-excel-for-the-web-98784ad0-898c-4...

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.