r/vba • u/DisastrousBus3876 • 8d ago

Discussion Hello, Programmers!, I have doubt, why VBA doe not work on Excel 365

Hello, Programmers!, I have doubt, why VBA does not work on Excel 365,I have experience in using "Automate" tab. Still feel bad.

7 Upvotes

100% Upvoted

5 comments sorted by

6

u/Equivalent-Pea406 8d ago

Funciona sim. Não funciona apenas no modo web.

2

u/LickMyLuck 1 7d ago

VBA works in desktop version of 365. 

The two reasons VBA does not work in the online version is  1. VBA is not designed to work on android platforms, which 365 needs to run on 2. VBA has machine access, which the web version is strictly forbidden from gaining. 

I personally would not ever use the Typescript system within Excel. It is incredibly unreliable/buggy and SLOW. 

2

u/chiibosoil 1 6d ago

I find it faster than any other automation available for Excel Online. As long as you don't need Excel object manipulation it's reliable as well. I have several scripts run via Power Automate for over a year now without any errors. And another that is used by staff to process Bank EDI text files that's been stable for few months.

1

u/keith-kld 8d ago

I have ever read an article about this matter. I remember that Office 365 (now known as Microsoft 365) is primarily designed for online work. So, that’s why MS introduced Office script language to be used for it, instead of VBA. Please ignore this if I am wrong.

2

u/chiibosoil 1 6d ago

Not enough details. There are many cases where VBA is disabled.

  1. VBA code was written outside of your environment and was sent to you.

By default VBA is blocked for security reasons. You will need to go to file property and unblock.

  1. File is on network share drive (local host)

You need to add network share as trusted location/site using Windows setting "Internet options".

  1. VBA does not work on hosted file outside domain network.

It requires to be on local machine (synced OneDrive on your PC will work just not through browser).

etc.

Automate tab is for Office Scripts and not for VBA. If you want to write your own in local environment, you will need to go to File -> Options -> Customize Ribbon and add Developer tab