+ Reply to Thread
Results 1 to 7 of 7

Fixing runtime error '53'

  1. #1
    Registered User
    Join Date
    04-26-2016
    Location
    singapore
    MS-Off Ver
    Office xp
    Posts
    20

    Fixing runtime error '53'

    Please Login or Register  to view this content.
    So I tried switching the sPath around but it will still have runtime error and made sure the path is correct. The line in red is highlighted when I debug.

    Edit

    Please Login or Register  to view this content.
    Last edited by Bronx; 04-28-2016 at 04:58 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Fixing runtime error '53'

    53 is a file not found, so I assume it is having trouble with your path. The x86 version has a space prior to C:\. Could that be causing a problem? I don't have a way to test this for you.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-26-2016
    Location
    singapore
    MS-Off Ver
    Office xp
    Posts
    20

    Re: Fixing runtime error '53'

    It would still have the error after the space is removed.
    but its okay thanks for trying!

  4. #4
    Registered User
    Join Date
    04-26-2016
    Location
    singapore
    MS-Off Ver
    Office xp
    Posts
    20

    Re: Fixing runtime error '53'

    Can you explain what does the "?" and "&" means? Should it be ";" instead?

    Please Login or Register  to view this content.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Fixing runtime error '53'

    You are using the wrong syntax for a Thunderbird command line. I'm surprised it generated 53 since the file was found, but you are probably get an error back from the command line. It should be in the form of

    thunderbird.exe -compose "to='[email protected],[email protected]',cc='[email protected]',subject='dinner',body='How about dinner tonight?',attachment='C:\temp\info.doc,C:\temp\food.doc'"

    so your code should be
    Please Login or Register  to view this content.
    Your code is trying to build an HTML mailto: tag, which is a different animal. I'll explain that as long as I'm here.

    ? - a series of command parameters follow
    & - another command parameter follows

    parameters are in the form of

    parameter_name=parameter_value

    You can see an example of this name/value pair syntax in URLs for PHP web sites, like the page you are looking at right now:


    http://www.excelforum.com/showthread.php?t=1137140&p=4374947

  6. #6
    Registered User
    Join Date
    04-26-2016
    Location
    singapore
    MS-Off Ver
    Office xp
    Posts
    20

    Re: Fixing runtime error '53'

    Finally found out that there should be a space between 'Files (x86)' which I missed out.....
    hue hue hue hue now it could run.

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Fixing runtime error '53'

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

+ 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. [SOLVED] Index range fixing error
    By silambarasan.J in forum Excel General
    Replies: 4
    Last Post: 01-27-2016, 06:44 AM
  2. Trouble fixing my error message box on vba
    By Rick23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2014, 12:46 AM
  3. Fixing Date Error -
    By JCL622 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2013, 10:54 AM
  4. [SOLVED] Help me in fixing the error
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-26-2012, 07:26 AM
  5. Fixing a sorting error for empty rows (error '1004')?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:20 PM
  6. Fixing a sorting error for empty rows (error '1004')?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  7. Fixing the #DIV/0! Error
    By kc2equ in forum Excel General
    Replies: 1
    Last Post: 02-22-2005, 11:32 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