Monday, December 3, 2018

Why Excel for iOS Doesn’t Support VB Macros

TJ Luoma:

Finally watched that “I tried to edit a movie on the iPad Pro” and this video editing professional is amazing and amazed at what it can do.

Commenter: “Yeah but Excel on iOS can’t do macros…”


I think the hardware can handle it.

Erik Schwiebert:

VB macros on iOS are forbidden by Apple. Review guideline 2.5.2 says in part that apps may not “download, install, or execute code which introduces or changes features or functionality of the app”.

I thought maybe Google Sheets would get around this by running the macros on the server, but apparently not.

Previously: iPad Pro 2018, How to Game the App Store, Hasta La Vista, Visual Basic.

6 Comments RSS · Twitter

The rule exists, but Pythonista and Scriptable are two apps that I can think of off the top of my head whose explicit purpose is allowing users to write and execute Python or Javascript scripts respectively. I wonder if MS has ever been explicitly told by Apple that VB macros would be rejected?

This rule is such a BS.. If an App downloads html/Javascript and presents it in UIWebview, it seems to be violating this rule right away, no?
"code" is such a vague term. JSON is also code, and apps change their behaviour based on settings/options/response downloaded from Internet

The linked article says Sheets macros aren’t available on iOS or on Android. That’s not a strong argument for the lack of macros being because of Apple’s policies.

I don't know what they are thinking not allowing this. Apple dumbing down stuff like this by outright excluding features is one of their worst traits.

Stupid thing is that all I am trying to do is automate my custom sorts and filtering of data. This is far from national security, but a game changer in terms of my ability to use items like Excel for business. Even worse, this was not explained when moving to the platform. My fault... buyer beware.

Well, that took the wind from my sails. Bummer.
I'm not a professional, but really wanted to be able to use my phone to use forms in Excel for simple logging on the road.
Is there a good software that I should be using to easily build an app in iOS?

Leave a Comment