+ Reply to Thread
Results 1 to 4 of 4

Prompt for save If Then statement errors with Error 13 Type mismatch??

  1. 12-10-2014, 11:50 AM #1
    Destroy
    Destroy is offline
    Registered User
    Join Date
    01-04-2014
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    55

    Prompt for save If Then statement errors with Error 13 Type mismatch??

    If I cancel the save box, it works properly and reloops through. But when I enter an actual file name it errors at the If line.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 12-10-2014, 12:27 PM #2
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Prompt for save If Then statement errors with Error 13 Type mismatch??

    Hi,

    Change the fname datatype to variant :

    Please Login or Register  to view this content.
    Regards
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  3. 12-10-2014, 05:00 PM #3
    Destroy
    Destroy is offline
    Registered User
    Join Date
    01-04-2014
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Prompt for save If Then statement errors with Error 13 Type mismatch??

    Thanks, that did the trick.
    Reply With QuoteRegister To Reply
  4. 12-10-2014, 10:42 PM #4
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Prompt for save If Then statement errors with Error 13 Type mismatch??

    You are welcome Destroy.

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If statement using InStr function using vbTextCompare is giving type 13 mismatch error
    By drjanand in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-27-2013, 12:16 PM
  2. Type MisMatch error (13) with if statement using loop
    By mdnghtsnpr in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-26-2010, 10:37 AM
  3. Type Mismatch Errors...
    By yellephant in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2007, 09:39 AM
  4. Type Mismatch Errors...
    By yellephant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2007, 09:32 AM
  5. [Q] Save As throws type mismatch error in control's code?
    By Jason Weiss in forum Excel General
    Replies: 1
    Last Post: 07-16-2005, 12:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1