+ Reply to Thread
Results 1 to 4 of 4

Runtime Error 438 - Object doesnt support this property or method

  1. #1
    Forum Contributor
    Join Date
    03-20-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    200

    Runtime Error 438 - Object doesnt support this property or method

    Hi
    please could someone tell me whats wrong with the below

    i get the errorr on
    Please Login or Register  to view this content.
    thanks in advance

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    03-20-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Runtime Error 438 - Object doesnt support this property or method

    side note

    if i put error resume next, it ignores data the first time, but on the second loop it works fine

  3. #3
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Runtime Error 438 - Object doesnt support this property or method

    I don't see the .body attribute for iedoc when debugging. To see this put a breakpoint on the line you are getting the error on, and put iedoc in your watch window. Then you can click on the + sign next to iedoc when the macro stops at the breakpoint and see all possible attributes.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!

  4. #4
    Forum Contributor
    Join Date
    03-20-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Runtime Error 438 - Object doesnt support this property or method

    ok will have a look thanks

    Very weird, the error seems to have stopped now and i havent done anything, but will try this if it pops up again and put in a error handler

    ty

+ 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 438, object doesnt support this property or method
    By 33CDonnelly in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-02-2013, 11:21 AM
  2. VBA Error: Object doesnt support the property or method
    By AntiPivotTable in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2013, 12:25 AM
  3. error "object doesnt support ths property
    By VBA-Snail in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2013, 10:45 AM
  4. Object doesnt support this property or method- error
    By kiran527 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2012, 09:39 AM
  5. macro error > object doesnt support property
    By jw01 in forum Excel General
    Replies: 1
    Last Post: 07-24-2011, 05:06 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