Results 1 to 25 of 25

Run-time error '5': Invalid procedure call or argument

Threaded View

mcbruce76 Run-time error '5': Invalid... 07-29-2013, 08:37 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 09:13 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 09:20 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 09:41 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 10:08 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 09:58 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 10:27 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 10:23 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 10:33 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 10:48 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 10:52 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 11:00 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 11:03 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 11:06 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 11:17 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 11:31 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 11:19 AM
mcbruce76 Re: Am getting error Run-time... 07-29-2013, 11:36 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 11:36 AM
ragulduy Re: Am getting error Run-time... 07-29-2013, 12:03 PM
mcbruce76 Re: Run-time error '5':... 07-29-2013, 12:19 PM
ragulduy Re: Run-time error '5':... 07-29-2013, 11:43 AM
mcbruce76 Re: Run-time error '5':... 07-29-2013, 11:57 AM
ragulduy Re: Run-time error '5':... 07-30-2013, 03:39 AM
mcbruce76 Re: Run-time error '5':... 07-30-2013, 08:31 PM
  1. #6
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Am getting error Run-time error '5': Invalid procedure call or argument. please help

    What happens if you load up internet explorer (or another web browser) and try and access one of the sites in your sample? Try:
    http://miami.craigslist.org/brw/pts/3949953392.html
    I'm thinking that as the code worked on one machine but not when you changed systems that maybe you have restricted web usage or the links are now dead.


    What happens if you run this code:
    Sub test()
    Dim rng, lr As Long, a, res As String, x As Long
    lr = Cells(Rows.Count, 1).End(xlUp).Row
    rng = Range("a2:b" & lr)
    x = LBound(rng)
    With CreateObject("MSXML2.XMLHTTP")
        .Open "GET", rng(x, 1), False
        .setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
        .send rng(x, 1)
        MsgBox .responsetext
    End With
    Range("a2:b" & lr) = rng
    End Sub
    Do you get a messagebox? What does it say?
    Last edited by ragulduy; 07-29-2013 at 10:23 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro Run Time error - Invalid procedure call or argument
    By clundeen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2011, 01:59 AM
  2. Macro Error - Invalid Procedure Call or Argument
    By mcordi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-12-2011, 05:40 PM
  3. Invalid procedure call or argument error
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2006, 06:45 PM
  4. [SOLVED] Run-time error '5': Invalid Procedure Call or Argument
    By Nikila in forum Excel General
    Replies: 2
    Last Post: 02-24-2006, 05:30 PM
  5. Run Time Error 5 - Invalid Procedure Call or Argument Q
    By John in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2005, 05:05 PM

Tags for this Thread

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