Home

Move from OnPrem to Online with Excel Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-738581%22%20slang%3D%22en-US%22%3EMove%20from%20OnPrem%20to%20Online%20with%20Excel%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738581%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20about%20to%20move%20our%20Clients%20from%20Office%202016%20to%20Office%20365%20and%20we%20have%20a%20MANY%20Excel%20Macros%20that%20are%20OLD%2C%20written%20Before%20year%202000%20and%20they%20are%20production%20critical.%3C%2FP%3E%3CP%3EI%20remember%20i%20have%20read%20somewhere%20that%20there%20is%20a%20tool%20that%20can%20check%20old%20Excel%20Macros%20if%20the%20can%20work%20also%20in%20Online%20version%20of%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20be%20great%20to%20check%20this%20Before%20we%20do%20the%20upgrade%20of%20the%20clients.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20anyone%20who%20can%20help%20me%20in%20the%20right%20direction%20in%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20all%20Answers%3A-)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EGunnar%20K%3C%2FP%3E%3CP%3ESweden%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738581%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738592%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20from%20OnPrem%20to%20Online%20with%20Excel%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738592%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319249%22%20target%3D%22_blank%22%3E%40Gunnar_K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EVBA%20does%20not%20work%20on%20Excel%20on-line.%20Period.%20%3C%2FFONT%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CSTRONG%3ELuckily%20upgrading%20to%20Office%20365%20does%20not%20mean%20you%20loose%20desktop%20Excel.%3C%2FSTRONG%3E%20%3C%2FFONT%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EDepending%20on%20the%20license%20you%20buy%20Desktop%20Excel%20is%20part%20of%20the%20deal%20and%20can%20be%20installed.%20VBA%20will%20then%20continue%20to%20work%20as%20before.%20Whether%20or%20not%20individual%20workbooks%20will%20function%20depends%2C%20but%20given%20that%20you're%20coming%20from%202016%20I%20would%20not%20expect%20too%20much%20trouble.%3C%2FFONT%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Gunnar_K
Regular Visitor

Hi

 

We are about to move our Clients from Office 2016 to Office 365 and we have a MANY Excel Macros that are OLD, written Before year 2000 and they are production critical.

I remember i have read somewhere that there is a tool that can check old Excel Macros if the can work also in Online version of Excel.

 

Would be great to check this Before we do the upgrade of the clients.

 

Are there anyone who can help me in the right direction in this issue?

 

I appreciate all Answers:-)

 

Regards

Gunnar K

Sweden

1 Reply

@Gunnar_K 

VBA does not work on Excel on-line. Period.
Luckily upgrading to Office 365 does not mean you loose desktop Excel.
Depending on the license you buy Desktop Excel is part of the deal and can be installed. VBA will then continue to work as before. Whether or not individual workbooks will function depends, but given that you're coming from 2016 I would not expect too much trouble.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies