+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Runtime error running macro to open IE and search for string

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Runtime error running macro to open IE and search for string

    Hello I am having a problem with this code:
    Please Login or Register  to view this content.
    Every time i try to run it comes up with "User-defined type not defined"

    Any ideas?
    Last edited by Paul; 08-04-2009 at 10:57 PM. Reason: Added code tags

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: problems with a code

    Hello Aaecae, welcome to the forum.

    Please take a moment to read the forum rules and in the future:
    1. Wrap your code in CODE tags. (Rule 3)
    2. Use a thread title that is more descriptive of your issue (Rule 1)

    Regarding your problem:
    1. In the VB Editor click Tools -> References, scroll down and select 'Microsoft Internet Controls' then click OK
    2. Update your code as shown below:
    Please Login or Register  to view this content.
    Last edited by Paul; 08-04-2009 at 11:00 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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