Excel Programming Language?

%3CLINGO-SUB%20id%3D%22lingo-sub-2904746%22%20slang%3D%22en-US%22%3EExcel%20Programming%20Language%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904746%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20visiting%20Excel%20programming%20after%20a%20long%20time%20and%20wanted%20to%20know%20if%20VBA%20that%20still%20exists%20within%20Excel%20will%20be%20supported%20going%20into%20future.%20I%20see%20ADO%20libraries%20within%20and%20am%20starting%20on%20a%20database%20solution%20into%20Excel%20with%20charts%20and%20wanted%20to%20know%20if%20this%20can%20be%20continued%20or%20there%20is%20another%20language%20that%20Microsoft%20would%20like%20us%20to%20use%20for%20programming%20Office%20apps.%20I%20am%20using%20Excel%20that%20comes%20with%20Office%20365.%20Would%20appreciate%20advice%20from%20those%20deeply%20into%20Excel%20programming%20and%20what%20is%20your%20recommendation.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EAKM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2904746%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2905286%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Programming%20Language%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1201028%22%20target%3D%22_blank%22%3E%40AK_Mirle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EVBA%20is%20still%20supported%2C%20and%20there%20is%20no%20sign%20that%20it%20will%20be%20discontinued%20-%20there%20are%20simply%20too%20many%20solutions%20depending%20on%20VBA%20for%20that.%3C%2FP%3E%0A%3CP%3EHowever%2C%20VBA%20only%20works%20in%20the%20desktop%20versions%20of%20Office%20applications%20for%20Windows%20and%20MacOS.%20It%20does%20not%20work%20in%20the%20online%20(browser)%20versions.%20In%20the%20online%20version%2C%20you%20can%20use%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fdev%2Fscripts%2Foverview%2Fexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOffice%20Scripts%20in%20Excel%20on%20the%20web%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2906096%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Programming%20Language%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2906096%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1201028%22%20target%3D%22_blank%22%3E%40AK_Mirle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20we%20speak%20about%20%22database%20solution%22%20perhaps%20Power%20Query%20and%20Power%20Pivot%2C%20with%20their%20M-script%20and%20DAX%20support%2C%20could%20be%20enough.%20These%20days%20to%20use%20OLE%20DB%20directly%20worth%20only%20for%20quite%20specific%20cases.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi All,

 

I am visiting Excel programming after a long time and wanted to know if VBA that still exists within Excel will be supported going into future. I see ADO libraries within and am starting on a database solution into Excel with charts and wanted to know if this can be continued or there is another language that Microsoft would like us to use for programming Office apps. I am using Excel that comes with Office 365. Would appreciate advice from those deeply into Excel programming and what is your recommendation. 

 

Thanks,

AKM

3 Replies

@AK_Mirle 

VBA is still supported, and there is no sign that it will be discontinued - there are simply too many solutions depending on VBA for that.

However, VBA only works in the desktop versions of Office applications for Windows and MacOS. It does not work in the online (browser) versions. In the online version, you can use Office Scripts in Excel on the web 

@AK_Mirle 

If we speak about "database solution" perhaps Power Query and Power Pivot, with their M-script and DAX support, could be enough. These days to use OLE DB directly worth only for quite specific cases.

Thank you @Hans Vogelaar and @Sergei Baklan for your input. Will use VBA as I need the Visual Basic GUI within, where in the user interacts with the data for selections, filters, etc.