+ Reply to Thread
Results 1 to 3 of 3

Runtime error 424 : Object required : VBA

  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    Motown
    MS-Off Ver
    Excel 2007
    Posts
    1

    Runtime error 424 : Object required : VBA

    TgtWB.VBProject.VBComponents.Import ("C:\Path\Module1_6_7_18.bas")

    Not sure why this command is giving error as runtime error 424; object required.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Runtime error 424 : Object required : VBA

    What is TgtWB?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Runtime error 424 : Object required : VBA

    Hi suren037, surprising to see you joined in 2012 but this is your first post... a little milestone

    I'm afraid that without any context, it is very hard to even begin to guess the problem. Based on the error and lack of surrounding code, my first guess would be that the TgtWB object has not been set?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ 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] runtime error 424 Object Required
    By pongmeister in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-02-2018, 12:36 AM
  2. VBA with IE: Runtime Error 424 - Object Required
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-05-2016, 03:47 PM
  3. Runtime Error 424 - Object Required
    By CBalazic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2015, 01:02 PM
  4. Runtime error 424 Object required
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2013, 09:37 AM
  5. Runtime Error '424' - Object Required
    By ffffloyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2011, 09:52 PM
  6. Runtime Error 424 - Object Required
    By teaker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2009, 04:04 PM
  7. Runtime error 424 - Object required
    By periro16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2005, 01: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