+ Reply to Thread
Results 1 to 4 of 4

Invalid Call procedure or arguement

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    wigan
    MS-Off Ver
    2007
    Posts
    78

    Invalid Call procedure or arguement

    Please Login or Register  to view this content.
    I am getting an invalid call arguement when running the following. It is falling down here:

    HTML Code: 
    If I take out the 'on error resume next' the bit that follows is highlighted in yellow when i try and do it.

    This worked yesterday and as far as I am aware there have been no changes. Is there anything that would make this code so temperamental?

    thanks,
    dan.

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

    Re: Invalid Call procedure or arguement

    What is the value of sFileName at the point where it fails?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-08-2014
    Location
    wigan
    MS-Off Ver
    2007
    Posts
    78

    Re: Invalid Call procedure or arguement

    it is determined by this
    HTML Code: 
    thanks,
    dan.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,762

    Re: Invalid Call procedure or arguement

    That's not what I meant. I can see how it's defined, but what is the actual value of that variable at the point where it fails?

+ 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. Run time error '5': Invalid procedure call or arguement (excel 2007)
    By Excel_novice1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2012, 05:40 PM
  2. Invalid Procedure Call (Mid fxn)
    By za20001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2011, 08:20 AM
  3. Invalid procedure call or argument
    By krish T in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2010, 10:01 AM
  4. error 'Invalid Procedure Call or Arguement'
    By chrismann85 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2009, 07:28 AM
  5. Invalid Procedure call or argument
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2006, 10: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