Visual basic equivalent for Mac?

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

  1. grizzelda73 macrumors member

    Feb 26, 2018
    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 6502a


    Aug 24, 2017
    Out there...way out there
    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


    Staff Member

    Jan 23, 2005
    If you select watch this thread, you will get a forum alert when someone replies.
  4. kryten2 macrumors 6502a

    Mar 17, 2012
  5. theluggage macrumors 68040

    Jul 29, 2011
    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


    Mar 3, 2010
    Second star on the right....
    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

    Mar 21, 2011
    Australia, Perth
    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 member

    Feb 26, 2018
    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 member

    Feb 26, 2018
    --- Post Merged, Mar 10, 2018 ---
    --- 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


    Aug 8, 2016
    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


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

    Mar 17, 2012
    Thanks for the tip. Learned something new.
  13. mpainesyd macrumors 6502a


    Nov 29, 2008
    Sydney, Australia
    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

12 March 6, 2018