Submitting XLM via VBA

jeskit · September 5th, 2012, 11:04 AM

Hi,

I have a database system which submits XML to external source. However It debugging on a line within the VBA code, however I don't understand what the line does. the line is

Code:

    Dim ws As clsws_TiRequestsService
    Set ws = New clsws_TiRequestsService

Can anyone tell me what these lines are doing as I dont understand what clws_TIRequestsService is in VBA? Also is there any reason why it would debug on this line?

If it helps before this line is code to put the data needed into a variable and also define the username and password for the login which is used after this code.

Thank you,

Kind regards

Jeskit

jeskit · September 5th, 2012, 11:28 AM

Hi, an update on my issue is the computer it crashed on had loads of programs open behind. Would this cause a problem?

JP · September 6th, 2012, 06:44 AM

Those lines are declaring and instantiating an object. That name looks like a custom class.

You should have either a class module with that name, or a project reference to a project with that name.