+ Reply to Thread
Results 1 to 5 of 5

Thread: wsm_SubmitTiRequestsAsXml clsws_TiRequestsService VBA code

  1. #1
    Valued Forum Contributor
    Join Date
    01-10-2011
    Location
    swindon, england
    MS-Off Ver
    Excel 2010
    Posts
    295

    wsm_SubmitTiRequestsAsXml clsws_TiRequestsService VBA code

    Hi

    I have been given this piece of code built into Access using VBA. I am trying to figure out what it all does. I have hit 2 bits of code and I do not understand them, does anyone recognise Them?

        Dim ws As clsws_TiRequestsService
        Set ws = New clsws_TiRequestsService
    ws.wsm_SubmitTiRequestsAsXml
    I have never heard if clsws_TiRequestsService before, does anyone know what it is?

    Thanks

    Jeskit
    Last edited by jeskit; 12-14-2011 at 07:27 AM.

  2. #2
    Forum Guru davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2007
    Posts
    1,879

    Re: wsm_SubmitTiRequestsAsXml clsws_TiRequestsService VBA code

    It is a class of some sort. There should be a class module with that name in it. If it isn't in a module, it must have been built as a dll, and then you should be able to find it in the references under Tools -> References...
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

  3. #3
    Valued Forum Contributor
    Join Date
    01-10-2011
    Location
    swindon, england
    MS-Off Ver
    Excel 2010
    Posts
    295

    Re: wsm_SubmitTiRequestsAsXml clsws_TiRequestsService VBA code

    Hi

    Thank you for replying. You were write it was class which is built by another website, however the code of that class is even more confusing

    But thank you for helping me. Could I ask how you knew it was a class?

    Thanks

  4. #4
    Forum Guru davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2007
    Posts
    1,879

    Re: wsm_SubmitTiRequestsAsXml clsws_TiRequestsService VBA code

    Hungarian notation uses the prefix cls to designate a class.
    Whoever wrote that code was using a form of that notation.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

  5. #5
    Valued Forum Contributor
    Join Date
    01-10-2011
    Location
    swindon, england
    MS-Off Ver
    Excel 2010
    Posts
    295

    Re: wsm_SubmitTiRequestsAsXml clsws_TiRequestsService VBA code

    Oh, ok I get it. Thanks I'll have to remember that. Thank you for all help!!

+ 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.2.0