Consulting

Results 1 to 4 of 4

Thread: AppleScriptTask command not working in VBA for Excel 2016 for Mac

  1. #1

    AppleScriptTask command not working in VBA for Excel 2016 for Mac

    I have an Excel file that makes heavy use of the MacScript command, which has been deprecated in Excel 2016.

    I attempted to use the new AppleScriptTask command as explained in this StackOverflow thread: https://stackoverflow.com/questions/...49324#30949324

    In VBA, I get run-time error 5 - Invalid procedure call or argument.


    Here's where I put the script file:

    script location.jpg


    Here's what the script file contains:

    script.jpg


    Here's the VBA code

    vba.jpg


    The run-time error is on the AppleScriptTask statement. Any ideas?

  2. #2
    Hi

    I use it in the Mail codes and I see you got my script file inside the folder.
    Take a look how I set it up and if you not get it working mail me private so I can maybe help you

  3. #3
    You can find the mail codes for 2016 Mac on this page

    Can't post the link to the mail page, look in the Mac section on my site

    I get this error :Post denied. New posts are limited by number of URLs it may contain and checked if it doesn't contain forbidden words.

  4. #4
    Ron, I really appreciate your reply! And the valuable content at your website. I'm sorry for losing track of this thread. I got caught up in a business acquisition, etc and needed to put Excel 2016 for Mac compatibility on the backburner. I anticipate getting into it again in the next few weeks, and will let you know how it goes here. Thanks again!

Posting Permissions

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