Introduction-to-Serial-Port-Comm.doc

<div>
Answer was generic, listing far more lines of code than I actually needed for my particular requirements. &nbsp;
</div>


Answer was generic, listing far more lines of code than I actually needed for my particular requirements.  

<div>
<div class="content wysiwyg-content">
I wish to read the state of several mechanical switches from within a Visual Basic macro running within MS Word or Excel on a laptop, preferable using a cable or IO module with a USB interface. &nbsp;Can this be done using a library function to access my DLP-IO8-G from a VB macro, or do I need another physical interface? &nbsp;
</div>
</div>


I wish to read the state of several mechanical switches from within a Visual Basic macro running within MS Word or Excel on a laptop, preferable using a cable or IO module with a USB interface.  Can this be done using a library function to access my DLP-IO8-G from a VB macro, or do I need another physical interface?  

How can I read the state of external mechanical switches from within a Visual Basic Macro?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.