+ Reply to Thread
Results 1 to 4 of 4

Runtime Error 53 Running Shell Script Mac

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    USA
    MS-Off Ver
    Mac 2016
    Posts
    2

    Runtime Error 53 Running Shell Script Mac

    I am trying to run a Shell script from Excel using VBA. The prompt which runs correctly in Terminal is
    Please Login or Register  to view this content.
    . The following code attempts to run that line, but raises
    Please Login or Register  to view this content.
    The notebook this script is attached to, prompt.csv, and runScript.sh files all live in the same folder. I am using Office 2016 for Mac. Any help is much appreciated.

    Please Login or Register  to view this content.

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

    Re: Runtime Error 53 Running Shell Script Mac

    So error is telling you that the file isn't found.

    Likely cause is that you need to use full path to your runScript.sh location (you may need to do the same for csv file path).
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    07-16-2019
    Location
    USA
    MS-Off Ver
    Mac 2016
    Posts
    2

    Re: Runtime Error 53 Running Shell Script Mac

    Quote Originally Posted by CK76 View Post
    So error is telling you that the file isn't found.

    Likely cause is that you need to use full path to your runScript.sh location (you may need to do the same for csv file path).
    When I specify the full path, I get a path not found error. Additionally, I would like to distribute this workbook so the full path would have to be dynamic. I am unsure how to concat ActiveWorkbook.Path and "/prompt.csv" within the Shell line without raising an error.

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

    Re: Runtime Error 53 Running Shell Script Mac

    Sorry, don't have access to Mac to test things out currently. Hopefully someone else can give you more insight into the issue.

+ 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. EMBED("Shell.Explorer. script error popup.
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2018, 06:16 AM
  2. [SOLVED] runtime error when running recorded macro
    By huangwh88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-14-2018, 10:12 PM
  3. calling the vb script from the shell script(unix platform)
    By chandanp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2014, 06:21 AM
  4. Runtime Error 13 - Type Mismatch while running Macro
    By rrajnish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2013, 02:01 PM
  5. Runtime error off simple script
    By DadaaP in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-06-2013, 10:41 PM
  6. runtime error 6 overflow when running a macro
    By Kim in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2006, 12:45 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