Attend Excelapalooza
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Office 365

  1. #1
    Board Regular jim may's Avatar
    Join Date
    Jul 2004
    Location
    Roanoke, VA
    Posts
    7,185
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Office 365

    Over the years I've been seeing the subject product increasing more and more in the MS office field.

    As I look through the features being offered off the Banner Ad here in Mr Excel - I do not see any
    reference or wording with regard to Visual Basic for Applications. Can someone clue me in on whether
    the VBA component is available in Office 365?

    Thanks,

    Jim May
    To display your spreadsheet data use either MrExcel HTML Maker or Excel Jeanie

  2. #2
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,970
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Office 365

    some discussion here > https://social.technet.microsoft.com...ffice2016ITPro looks like it should be available, though I'm not sure what works when its in a cloud
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  3. #3
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    31,614
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Office 365

    Office 365 is a subscription, not a product as such. It includes full desktop versions of Office (which one is dependent on your subscription level), which support VBA. The online version of Office (which is not actually related to 365) does not support VBA in any way, and nor will it.

  4. #4
    New Member
    Join Date
    Jun 2017
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Office 365

    Quote Originally Posted by RoryA View Post
    Office 365 is a subscription, not a product as such. It includes full desktop versions of Office (which one is dependent on your subscription level), which support VBA. The online version of Office (which is not actually related to 365) does not support VBA in any way, and nor will it.

    Roy A.

    I have both Office 365 and Office 365 Pro Plus (on separate computers but hosted in the cloud as a subscription service) and both support VBA (fully as far as I can tell). Have not noticed any limitations, in my use. I am running into issues with potential limitations in the Data Model but haven't eliminated user error.

    jarummel

  5. #5
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    31,614
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Office 365

    You are talking about the software that is installed on your computer which does, as I said, support VBA. The version of Excel that runs online in a web browser does not support VBA, and never will barring a fundamental and miraculous shift by Microsoft.

  6. #6
    New Member
    Join Date
    Jun 2017
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Office 365

    Quote Originally Posted by RoryA View Post
    You are talking about the software that is installed on your computer which does, as I said, support VBA. The version of Excel that runs online in a web browser does not support VBA, and never will barring a fundamental and miraculous shift by Microsoft.

    Sorry, didn't realize you were speaking of the Office "apps" that only run on a browser. Yes, I'm sure that version does not support VBA.

    jaustin

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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