+ Reply to Thread
Results 1 to 3 of 3

a different run time 13 type mismatch error

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    a different run time 13 type mismatch error

    I posted earlier about my FileCopy function issues but got no response so amended the code to the following.

    Please Login or Register  to view this content.
    When I type in filecopy syntax it wants the file source as string so I used TPath but I don't think this is right and I can't use wbt or HR4 as they aren't string variables. Currently it highlights the "open" in Set wbt and provides a Run Time 13 Type Mismatch error.

    I'm confused as to how to set this up, I've been working on this since before the weekend and it's driving me crazy. Any help is appreciated
    Last edited by Sc0tt1e; 10-07-2014 at 06:25 PM.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: a different run time 13 type mismatch error

    What's the value in BA4?

  3. #3
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: a different run time 13 type mismatch error

    BA4 value
    Please Login or Register  to view this content.
    BA5 value
    Please Login or Register  to view this content.
    Last edited by Sc0tt1e; 10-07-2014 at 06:23 PM.

+ 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] Run-time error '13': Type mismatch
    By Aeneren in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2014, 01:52 PM
  2. Run Time Error 13 Type Mismatch
    By nahge123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2012, 05:46 PM
  3. Run time error - type mismatch
    By justinng in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-10-2009, 11:24 PM
  4. Run time error: Type mismatch
    By Johannekie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2008, 09:11 AM
  5. [SOLVED] Run Time Error 13 Type Mismatch
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2005, 08: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1