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

The purpose of this article is to demonstrate how you can perform serial port communication in the VBA (Visual Basic Applications - script editor included. The purpose of this article is to demonstrate how you can perform serial port communication in the VBA (Visual Basic Applications - script editor included. CheapComm was written to permit Visual Basic, Excel. CheapComm only exposes the most basic operations of the serial port. Excel Com port communication. These examples are suitable for use in Visual Basic, Word, Excel and Access. The serial port ActiveX object can be inserted by VBA code (see the first example) or be manually inserted into form, worksheet or document.

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? Ford Car Manuals Pdf here. Library recommendations?

I'm having trouble getting code to read the incoming data send by a torque reader I'm working with. It sends a RS232 data stream which our current wedgelink software can be set up to translate it into key presses and then exported to excel.

I would like to get the data into a string then cut the string up into an array of arrays to be able to use the data directly with excel. There is a ton of stuff how to do it in other languages but I'm limited to VBA right now. This link has the base code someone wrote where i can open and close the port but im not getting any data or able to hold it open until end of the data feed. I'm still new at this and know I'm missing something. Was the first place i found this code.

Adobe Premiere Pro Cs4 32 Bit Full Cracked. Sub OpenPort_Click() Dim intPortID As Integer ' Ex.