+ Reply to Thread
Results 1 to 5 of 5

Excel with VBA not opening on an iPad or iPhone

  1. #1
    Forum Contributor
    Join Date
    10-13-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2007
    Posts
    401

    Excel with VBA not opening on an iPad or iPhone

    Greetings,

    Thank you in advance for any replies.

    I'm in charge of writing and maintaining a bunch of macro enabled Excel files for the managers of our various units. The macros simply open other Excel files, read and extract data from them, and create graphs and tables and such. The macros save the managers lots of time, as otherwise they would have to do it all by hand each month. They then later send these same files directly to the President, for him to review.

    He (the President) recently told me that one of the Excel files sent to him won't open on his iPad nor on his iPhone. It only opens up on his PC. All of the others open just fine with his iPad and iPhone. I don't have an iPhone or an iPad so I can't test this. Does anyone know the likely cause?

    I suspected the eventual answer would have something to do with the macros. So I saved that file as a regular Excel (xlsx) file, minus all of the macros, and sent it back to him. He says he could open that file...but not access the tabs, for some reason.

    I realize this is somewhat of a general question, but can anyone tell me the possible problems with macro-enabled Excel files when accessed with an iPad and an iPhone? Are there certain statements that cause those devices to not open the file? Is it security related and can he turn that off that security for these managers, since he knows these files are okay?

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,177

    Re: Excel with VBA not opening on an iPad or iPhone

    Macros certainly won't run on on iOS. I haven't tried an xlsm, but I can't open an xlsb at all on ios (with the default viewer anyway)

  3. #3
    Forum Contributor
    Join Date
    10-13-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2007
    Posts
    401

    Re: Excel with VBA not opening on an iPad or iPhone

    Thanks for responding.

    Note that he doesn't need or even want the macros to run. He's just examining the data in the file at this point. But yet he can't open one of the files at all, like he can with all of the others. They are all similar, so I'm at a loss as to why this one file is giving him problems.

    When I saved that file as an xlsx file, as a test, it no longer contained any macros at all. He could now open it... yet he couldn't access the worksheet tabs.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Excel with VBA not opening on an iPad or iPhone

    It really depends on what viewer/app he's using to open the file.

    Does he have MS Excel app for ipad?
    https://itunes.apple.com/ca/app/micr...586683407?mt=8

    MS Excel app is able to open .xlsb on my iPhone and able to see Pivots etc.

    And yes, macro won't work on iPad/iPhone.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  5. #5
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013
    Posts
    276

    Re: Excel with VBA not opening on an iPad or iPhone

    I tried many times. But macros are not supported on android or iphone.
    Don't wait for the PERFECT MOMENT
    take the moment and make it PERFECT
    Amir

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MS Excel file when opened on my iPhone ?
    By RustyNail in forum Excel General
    Replies: 2
    Last Post: 08-06-2016, 10:46 PM
  2. Excel on iPad
    By mills49 in forum Excel General
    Replies: 27
    Last Post: 04-17-2014, 03:52 AM
  3. Please help excel functionality on iPhone
    By Patsoe in forum Excel General
    Replies: 1
    Last Post: 11-13-2012, 08:18 AM
  4. Excel Audio to iPad
    By ISUCyclones in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2012, 12:24 PM
  5. Excel on an iPad
    By Andythefish in forum Excel General
    Replies: 4
    Last Post: 04-25-2012, 10:33 AM
  6. Excel and iPad
    By Botts750 in forum Excel General
    Replies: 2
    Last Post: 10-01-2011, 06:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1