Compile Error - VBA

[borski88]

Function pullDataSingleURL(URL As String, ws As Worksheet)
    [COLOR=#ff0000]Dim httpRequest As XMLHTTP      'XML V6.0[/COLOR]
    Dim DataObj As New MSForms.DataObject   'Forms 2.0
                                                
    Set httpRequest = New XMLHTTP
    httpRequest.Open "GET", URL, False
    httpRequest.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    httpRequest.send ""
    
    DataObj.SetText httpRequest.responseText
    DataObj.PutInClipboard
    
    DoEvents
    
    With ws
        .Activate
        .Cells.Clear
        .Cells(1, 1).Select
        .PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False, NoHTMLFormatting:=True
    End With
End Function

This code works fine on my computer and a co-workers computer, but it breaks at the highlighted red line when its run by our boss. figures, right?

The following references are enabled:
http://imgur.com/izV45Eo

 

[GTO]

I cannot see your link due to restrictions from personal storage on the PC I am at. At least for me, the 'Available References' window displays "Microsoft XML, v6.0" with a location of C:\Windows\System32\msxml6.dll. On your boss's PC, can you locate this dll? (Regardless of folder location)

 

[borski88]

I sent the wrong image originally:

 

[borski88]

I cannot see your link due to restrictions from personal storage on the PC I am at. At least for me, the 'Available References' window displays "Microsoft XML, v6.0" with a location of C:\Windows\System32\msxml6.dll. On your boss's PC, can you locate this dll? (Regardless of folder location)

Yes, that is enabled on my bosses PC.

 

[chicagocomputerclasses]

You probably have different windows versions.
Check this topic
http://www.mrexcel.com/forum/excel-questions/967890-microsoft-xml-v6-0-not-working-excel-2013-a.html

 

[borski88]

yes, he has windows 10, I have windows 7.
is it possible to have the file able to run regardless of the OS?

 

[chicagocomputerclasses]

MSXML2.DOMDocument60 should be available on both if I'm not mistaken.

 

[borski88]

MSXML2.DOMDocument60 should be available on both if I'm not mistaken.

thank you! seems to have worked!

 

[chicagocomputerclasses]

Glad it worked out for you