Vba Serial Port Programming

Vba Serial Port ProgrammingVba Serial Port Programming

'Can anyone supply a code snippet that will allow me to read a digital scale connected to Port 5, 2400 Baud 8-N-2? I have a digital scale. I think if I only knew what API calls to make from VBA that would be the best solution?

What is the best way to access a serial port from VBA? Ramones Too Tough To Die Blogspot Download Music more. 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. 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?

'ch************@yahoo.com' I searched a long time for something like this: It's free and it works fine. Drops right into a standard access module and the example program is trivial to hook up. No ocx to screw with. No stupid registration with the author. Totally free.

Thanks for posting. My web page and blog has been updated. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages.

Microsoft Access Links, Hints, Tips & Accounting Systems at Tony's Microsoft Access Blog. And thank you, Tony, for posting.

I thought it was a scam, so I ignored it. I'll take a look now.

'Tony Toews [MVP]' >I searched a long time for something like this: It's free and it works fine. Ek Kasak Dil Ki Dil Mein Title Song Mp3 Free Download on this page. Drops right into a standard access module and the example program is trivial to hook up. No ocx to screw with. No stupid registration with the author. Totally free. Thanks for posting.

My web page and blog has been updated. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at Tony's Microsoft Access Blog.