compile error on code in one workbook and not the other.

Hi guys

I had this code working in a blank workbook
i then put it straght into another workbook and now whenever i run it it comes up with an error message saying:

Compile error:
User-Defined type not defined

i dont think i did anything different
i also copied it into a new blank workbook and it dosent work either.

still works in the original sheet though.

Public Sub LaunchJaguar()
    Const strURL_c As String = "https://jaguarlandrover.leapfile.net/fts/drop/jlr/portal/Login.jsp"
    Const strUsr_c As String = "[email protected]"
    Const strPwd_c As String = "xxxxxxx"
    Dim objIE As SHDocVw.InternetExplorer
    Dim ieDoc As MSHTML.HTMLDocument
    Dim tbxPwdFld As MSHTML.HTMLInputElement
    Dim tbxUsrFld As MSHTML.HTMLInputElement
    Dim btnSubmit As MSHTML.HTMLInputButtonElement

'    On Error GoTo Err_Hnd
     'Create Internet Explorer Object
    Set objIE = New SHDocVw.InternetExplorer
     'Navigate the URL
    objIE.navigate strURL_c
    
     'Wait for page to load
    Do Until objIE.readyState = READYSTATE_COMPLETE: Loop
         'Get document object
        Set ieDoc = objIE.document
         'Get username/password fields and submit button.
        Set tbxPwdFld = ieDoc.all.Item("password")  'name of the username textbox
        Set tbxUsrFld = ieDoc.all.Item("email")  'name of the password textbox
        Set btnSubmit = ieDoc.all.Item("signIn")            'name of the submit button on the form
         'Fill Fields
        tbxUsrFld.Value = strUsr_c
        tbxPwdFld.Value = strPwd_c
         'Click submit
         
        btnSubmit.Click
objIE.Visible = True

objIE.navigate "https://jaguarlandrover.leapfile.net/fts/drop/jlr/portal/Downloads.jsp"
        
         'Wait for page to load
        Do Until objIE.readyState = READYSTATE_COMPLETE: Loop
Err_Hnd: '(Fail gracefully)
        End Sub

You need to ensure that any references you had enabled in the workbook that it works in are also enabled in one that you copy the code to under Tools...References in the VBA Editor.

Dom

ahh sorted it now thanks guys.

i didnt realise that the enabled references where dependant on the workbook
i thought it was set for all workbooks.

that link dosent work bud.
but i would be interested in that.
anychance of a repost?
web address is http://www.*****-clicks.com/excel/olBinding.htm

for anyone else who is interested its
http://www.D~I~C~K~S-clicks.com/excel/olBinding.htm
removing ~

I'd think twice about opening a website called that at home let alone in the office!!!

Dom

It's almost as unfortunate a name as expertsexchange.com before they twigged and added the -

Dom

oh my god expertsexchange.com thats classic.
site is legit for anyone who is unsure

and very helpful, thanks again kyle