none
set MSCOMM object with VBA

    Question

  • Not sure whether this is the right place to post my question.

    I have set reference to my Access app with MSCOMM32.ocx.

    I try to set an object where I can use that to read the proporties, etc.

    Question is how to I use VBA code to set the object.

    Kindly advsie.

    Thank you.


    TS Lim

    Monday, March 12, 2012 3:02 AM

Answers

  • Hi TS Lim,

    I would personally avoid using ActiveX objects, but if you insist, see below example on how to use it.

    Basicly put the ActiveX Object in your Form and then you can start using it.

    See below article in VB, with little re-writing usable in VBA:

    http://support.microsoft.com/kb/194922

    Alternatively you can use an API for this, check below thread for that:

    http://www.thescarms.com/vbasic/commio.aspx

    Another KB article which describes both methods using ActiveX and WinAPI in VB.Net, which with a little re-writing applicable for in VBA:

    http://support.microsoft.com/kb/823179

    Hope this helps,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

    Please vote an answer helpful if they helped. Please mark an answer as an answer when your question is being answered.

    • Marked as answer by TS Lim Tuesday, March 13, 2012 12:22 PM
    Monday, March 12, 2012 6:18 AM