excel VBA web service give error METHOD OR DATAOBJECT NOT FOUND -

I have a strange problem with the Excel VBA app.

It uses a Web service to connect a MySQL database.

All of this runs well in most computers .... However, in some computers it throws an error:

error when "method or data is not found"

All computers are running Windows 7 and Office 2007.

Here is an example of the web service code (where the error occurs)

  public function wsm_get_portscountries (string as ByVal str_SQLQuery) error on MSXML2.IXMLDOMNodeList GoTo wsm_get_portscountriesTrap set Exit wsm_get_portscountries = sc_WebService1.wsm_get_portscountries (str_SQLQuery) function wsm_get_portscountriesTrap: WebService1ErrorHandler "wsm_get_portscountries" end function  

The error highlights the bolded part here:

sc_WebService1. wsm_get_portscountries (str_SQLQuery)

Has anyone encountered the same problem ?? any idea ?? As I said, on most computers it runs well, there is no problem, it only happens with some.

Thanks in advance.

Additional information: class module

  Private all Class_Inisize () Geto class_inisation error string on gate at string_sw_sls string string_swls = "" set sc_WebService1 = new SOPCLANT 30 sc_WebService1 ConnectorProperty ("ProxyServer") = "& lt; CURRENT_USER & gt; Sc_WebService1.ConnectorProperty (" EnableAutoProxy ") = True Exit Sub Class_Initialize_error: End Sub    / Pre>