I'm not sure if the OPEN actually sets up the Baud rate, as I first used TeraTerm. Input_Buffer = Input_Buffer & Chr(COM_Byte) ' assemble output bufferĬOM_Byte = Asc(Mid(Output_Buffer, Chars2Send - CharsRemaining, 1)) Received_Lines = Received_Lines + 1 ' keep track of received line count Lfsr = &H3FFFFFFF - 2 ^ (Received_Lines And 15) Input_Buffer = "" ' and clear input buffer If COM_Byte = 13 Then ' look for CR line termination How should I go about handling this? Any good tips or tricks? Library recommendations? Compatibility with anything else would be a nice bonus though. I should be able to say it has to run on Office 2007 and Windows XP. 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 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. 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. 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. 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. Normally I would turn it into an application of some sort, but I actually don't think the idea is that bad. I don't commonly use VBA, especially for anything like this. 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. What is the best way to access a serial port from VBA?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |