Visual basic equivalent for Mac?

Discussion in 'Mac Apps and Mac App Store' started by grizzelda73, Mar 6, 2018.

  1. grizzelda73 macrumors newbie

    Joined:
    Feb 26, 2018
    #1
    Can I first apologise for my posting I've barely had the account for a week and this is my 3rd ask, I was curious to know if Apple had a similar application to Visual basic for applications which accompanied my edition at least of MS Office XP (2001) enabling the writing of macros for the app's Word Excel, Outlook & Access.
    Ps. Can I also ask who the 'watch this thread' checkbox refers to below.
     
  2. TiggrToo macrumors demi-goddess

    TiggrToo

    Joined:
    Aug 24, 2017
    Location:
    Out there...way out there
    #2
    Unsure what you're asking for here - mind elaborating? Are you, for example, asking if there's some really old 2001 app that you can run on a MacBook Pro today that has VBA functionality:eek:, or you wondering if it's available in newer apps today?

    I'd it's the latter then yes, Office 2016 for Mac has VBA functionality (albeit with some small, but annoying, differences).
     
  3. Weaselboy Moderator

    Weaselboy

    Staff Member

    Joined:
    Jan 23, 2005
    Location:
    California
    #3
    If you select watch this thread, you will get a forum alert when someone replies.
     
  4. kryten2 macrumors 6502a

    Joined:
    Mar 17, 2012
    Location:
    Belgium
    #4
  5. theluggage macrumors 68040

    Joined:
    Jul 29, 2011
    #5
    The current Mac versions of Word and Excel include Visual BASIC for Applications (Under Tools -> Macro).

    Be warned - there's no version of MS Access for the Mac and while there are Mac databases, there's nothing really like Access (feel free to add "fortunately" to that if you're an RDB whizz). If you're a heavy Access user, that's one of the few good reasons to stick with a PC.

    As others have mentioned, Apple's equivalent is AppleScript and the "Automator" application.
     
  6. jaduff46 macrumors 6502

    jaduff46

    Joined:
    Mar 3, 2010
    Location:
    Second star on the right....
    #6
    As noted above by @theluggage VBA is available is available for Office 2016. No Access however.

    Really depends on what you're trying to do. If it's just automating workflow it might meet your needs, as AppleScript also might. If it's more serious number crunching, perhaps not.
     
  7. Tech198 macrumors G5

    Joined:
    Mar 21, 2011
    Location:
    Australia, Perth
    #7
    Sorry... Windows is really the only true way here..

    While its possible with Office and Visual Basic functionality, its just not going to be the same as Microsoft. You can script it yourself (translation) to Apple, but why should you ? That takes all the fun out of writing VB in the first place, not to you'll increase your troubleshooting skills more when it does go wrong. and it will...

    Noting cross platform code ever works right does it?

    There is nothing like the real thing... This is why i keep a Windows virtual machine handy for other stuff too
     
  8. grizzelda73 thread starter macrumors newbie

    Joined:
    Feb 26, 2018
    #8
    No, in my ignorance I first thought Access would be one of the simplest programs to use, I mean how difficult can a database app be after using Lotus Approach.
     
  9. grizzelda73 thread starter macrumors newbie

    Joined:
    Feb 26, 2018
    #9
    --- Post Merged, Mar 10, 2018 ---
    Thanks.
    --- Post Merged, Mar 10, 2018 ---
    Thanks for your help.
    --- Post Merged, Mar 10, 2018 ---
    Yes a more succinct original post would have saved the efforts of about six or seven people, I've certainly learned something but have also revealed my deficiency in all matters Apple. Thank you.
     
  10. organicCPU macrumors 6502a

    organicCPU

    Joined:
    Aug 8, 2016
    #10
    If you're not absolutely tied to MS Office and VBA, I recommend trying LibreOffice instead. It has powerful scripting capabilities and there are several database connectors available.
     
  11. superscape macrumors 6502a

    superscape

    Joined:
    Feb 12, 2008
    Location:
    East Riding of Yorkshire, UK
    #11
    100% true, but the AppleScript implemention is horrible - at least for Excel and Word.
     
  12. kryten2 macrumors 6502a

    Joined:
    Mar 17, 2012
    Location:
    Belgium
    #12
    Thanks for the tip. Learned something new.
    :D
     
  13. mpainesyd macrumors 6502

    mpainesyd

    Joined:
    Nov 29, 2008
    Location:
    Sydney, Australia
    #13
    If you need a scriptable relational database then Filemaker (an Apple product) is OK. A big advantage is that its data files work in Windows and macOS (just like Word files). A big disadvantage is that conversion of data from MS Access is tedious and you will need to start from scratch with scripts/programming.
     

Share This Page