Excel with macro (and VBA) on Tablet and Mobile
we need (I'm not alone!!) as soon possible the possibility to use Excel with macro (and VBA) on Tablet and Mobile
if they want excel to survive in the market then a generic version for mobiles is needed , so why dont microsoft just make them built in function by asking the community what they require and then make a mobile version with the ones that they feel are appropriate and do not cause any conflicts with security .
an example :-
an "array loop button"
(that would allow you to loop through a set of cells with functions)
you could set the array say b7, b12 then set a loop counter and then a exit cell with true or false function ,
this could update these affected cells without a sheet calculation if needed.
im sure everyone could give ideas for new built in functions so let list them for microsoft .
Can’t Microsoft make a tablet that specifically solves this problem for those of us just needing to have a portable excel option?
it's gonna be a whole lot limited because imagine you have a macro that would print a specific area. your phone is not gonna know what a printer even is, or be able to have the same language a computer speaks to the printer anyway. maybe if it were a true windows phone, like some of those tablets out there.
they ask for suggestions, and this is the most asked for update, so why have microsoft not replied or given a good reason that this cannot be done ? they could even ask what features of a limited vba or macro would be an advantage to have , for me buttons and next loops to manipulate cell values ... what your thoughts and ideas , i think vba access outside of excel will never happen for security reasons ?
K Bennett commented
I need VBA on a tablet
You recommended we goto Android to get the best experience of Microsoft on mobile. This is so not true. These features are pretty basic in my mind. I mean all I'm trying to do is click a check box on a Exel file, and this is not possible??? This is so important for my work. I thought this was because I had a free version, but even paying for office 365 doesn't make a difference. This is basic stuff for mobile productivity. Microsoft you are seriously dropping the ball here.
R. G. Livesey commented
I use VBA a lot usually for my own functions so microsoft adding functions to excel would not help. Need VBA.
[Deleted User] commented
why take it so lot of time
Damned fail. I need VBA on tablet
Of course just a bunch of childish excuses prevent to Microsoft to explain us why they don't want us to have VBA on mobile devices. The real reason is only one:
It happens all the times, companies removes feautures to their products to push us to buy what they want sell us.
Michael O'Connor commented
Devastated Excel won't run macros on my 10" Windows tablet!!
I bought it specifically because the 'word out there' was Excel won't run VBA on anything smaller.
Spent an age working on my desktop to develop a really useful time saving application only to find that when I moved to my Windows 10 tablet PC it refuses to run.
Come on Microsoft! please!!! So frustrating - I'll have to re-write the whole thing in Java now - what a waste of precious time. :(
If there is now Excel Mobile Desktop app why not implement vba support? Voting for support of this request.
I use Android on a 10" screen.
My Excel workbook using VBA on a PC creates files for use with a browser. So the feature is not just a matter on enhancing functions.
As I am away from my PC for weeks at a time I need the ability to run VBA (or whatever) in a workbook on both PC and Android tablet.
I vote in support of the request.
I've made a template filled with macro's, working just fine on a tablet (Windows)... It works as wanted, just lacks some speed when the connection with the server has to be made...
Then again the tablet isn't the best available (3go)... But yes, it would make everything lot's better if the same template could work with Android.
As already stated in other post I totally agree. It is senseless say that we have to pass on Azure, which was the answer that I got. People have too many excel files with macros already done, at it makes too much sense to develop VBA also for android and in general mobile solutions. Pleaseeeeeeee!!!!
Having access to MS Onedrive is good, and it will jump to a great level of service if VBA will be added to Ipad, and etc.
As an engineer, I have custom equations that I want to model so hence having VBA support is necessary or the spreadsheets get very messy. Also, it interrupts the workflow, when you need to check or rerun a value on the go on your device you cannot unless you are on the desktop version. Hence it's really essential.
yes i agree and vba that does not call out of excell should not cause any secutity concerns,
my code does things like resets to cells after calculations to retry. and generate some cells with random numbers ie 1 to 30 into cells with no duplicated numbers.
and handy buttons to either work in edit mode or run mode with all menus ect hidden .
just a few examples. im self taught so just write code when i need it..
Rob Cole commented
Hey Alex. I use VBA in Excel for way–way more than just user defined functions. That would not do it. I could get by with the subset of VBA that MS has created with its "Sandbox" limitations in Office 365, 2016, and 2019. And since they have already worked out these VBA limitations to be within the App Guidelines against executing code outside the container for OS, it seems like the next step would be the easier portion to port that over to iOS. They have already engineered the hard part. I don't think we're asking that much of them. It's just not a priority for them.
lets face it, we use macros and vba because microsoft excel does not incorporate the functions we want to use, so why does microsoft not add the functions to excel and most users would not require vba.
anyone with good ideas for adding a function give your ideas and lets all tell microsoft what we require.