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.
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:
Alternatively you can use an API for this, check below thread for that:
Another KB article which describes both methods using ActiveX and WinAPI in VB.Net, which with a little re-writing applicable for in VBA:
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.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?