Look at most relevant Excel dtr programming websites out of 197 Thousand at KeyOptimize.com. Excel dtr programming. #10 /serial-port-communication-in-excel-vba.

What is the best way to access a serial port from VBA? I have a need for some of our sales reps to be able to send a simple string over the serial port from an action button in PowerPoint. I don't commonly use VBA, especially for anything like this. Doves The Last Broadcast Rarest. Normally I would turn it into an application of some sort, but I actually don't think the idea is that bad. It will be a handy tool for them to demo this device with while on a projector and talking to other sales guys and non technical people. Also, this sales guy will have no problem making small modifications to the VBA or PowerPoint presentation, but would not do as well with recompiling a.NET application.

I know we could do it through a batch file run from the presentation on the action, but that doesn't make me very happy. I figure we could probably access a COM object and run from there, but again I am not real up on the latest and greatest libraries to use in VBA, and it would also be nice to get a quick little primer in how to easily open, send and close the connection. Since this will need to be run on multiple people's computers, it would be nice if it would be easily transportable to other machines. I should be able to say it has to run on Office 2007 and Windows XP. Compatibility with anything else would be a nice bonus though.

How should I go about handling this? Any good tips or tricks?

Library recommendations?

» » » Using ActiveXperts Serial Port Component with VBA (Visual Basic for Applications) ActiveXperts Serial Port Component is a software development kit (SDK) that enables the user to communicate to a device over a serial interface. Such a device can be: a weight indicator, a modem, a scanner, or any other device that is equiped with a serial port.

It can even be another PC, connected via a NULL modem cable. ActiveXperts Serial Port Component features the following: • Direct COM port support (like 'COM1') • TAPI (Windows Telephony Device) support (like 'Standard 56000 bps Modem'); • Support for RS-232/RS422/RS485, up to 256 simultaneous ports; • Support for all types of Hayes compatible modems; • Support for serial cable as well as USB cable or Bluetooth connections; • Support for Virtual COM ports (i.e. COM ports redirected through the network); • Hardware flow control (RTS/CTS, DTR/DSR) and software flowcontrol (XON/XOFF) support; • Configurable baudrate/parity/stopbits, full buffered data transfer, text/binary data transfer. Step 1: Download and install the ActiveXperts Serial Port Component Download the ActiveXperts Serial Port Component from the and start the installation.

So Yesterday By Scott Westerfeld Pdf To Word. The installation guides you through the installation process. Step 2: Create a new Excel document Create the form displayed in the image below. To create the buttons, textarea's and drop down menu's, click 'View', 'Toolbars', 'Control toolbox'. (Click on the picture to enlarge) Step 3: Fill in the dropdown-menu's Wen you're finished setting up the form, you need to fill in the dropdown menu's.

You need to load the content of your submenu when you open your workbook.You can do this using a visual basic code. To edit your visual basic code you need to be in design mode. To get in design mode, click the button 'Design mode' on the control toolbox.

You can edit the visual basic code behind your form in Excel by clicking the button 'View code' below 'Design mode' on the control toolbox. Open 'ThisWorkbook'. (Click on the picture to enlarge) Type the following code in private sub workbook_open(): Make sure you're directing to the right sheet (worksheets('sheet1')).