This is for people experienced with VBA. It's some VBA code that I have found on the Net and have found very useful in Excel. It allows serial input into Excel without having the need to use MS Comm controls. So it's much easier to distribute an Excel solution to people across different versions of windows and without worrying about library references. I can't say I even understand some of it, but it works! All credits to the author: David M. Hitchner Put the comms code into a module.

I've had to split the code into 2 files, just add 2 below 1. Well I'm not sure this is going to help you, because if you don't have experience of using VBA in Excel then this is probably just going to generate a series of questions. Excel has a very comprehensive help system to teach you about VBA - that's the way I learnt, through many hours of hard work. Simply right click on any worksheet tab and you'll see a menu item saying 'view code'. Click that and it will take you into the Visual Basic editor. Then select Insert>Module from the menu. Then paste the code I supplied into the module.

I'm sorry, you will have to work it out for yourself. I've given some advice above about the key things to call. The actual code itself is very complex for a novice, however it offers a very nice direct communication path into Excel, without the fuss of having to check on libraries etc. Good luck - you might need it. I've generally steered away from APIs as most of the examples in the Visual Studio help seem to be directed at C++ type languages and they use slightly different commands or syntax. I have used the API viewer in VB6, but without some guidance you can import a bunch of irrelevant stuff that doesn't seem to do very much.

I have managed to get one very handy set of APIs to work which I use quite a lot. It allows you to call an external executable and wait until it is finished before moving on to the next line of my code. Drivers License Application Ireland.

Find the best Housing Specialist resume samples to help you improve your own resume. Each resume is hand-picked from our large database of real resumes.

Note: this example is tailored to the first time Visual Basic for Applications user, but the information is useful for the advanced user that is unfamiliar with serial port control. Click here if you're familiar with VBA and want to jump directly to the code segment. Let's get started: For this demonstration we will use Excel's VBA editor. Via RS232 to COM1. (The actual connection is via a COM to USB cable.) Small records of 10 charracters + Carriage-Return are sent per communication. I can receive the data with Hyper Terminal program of XP on COM1. If I could direct the data to EXCEL then I could resume with the data collection.

I've generally steered away from APIs as most of the examples in the Visual Studio help seem to be directed at C++ type languages and they use slightly different commands or syntax. I have used the API viewer in VB6, but without some guidance you can import a bunch of irrelevant stuff that doesn't seem to do very much. I have managed to get one very handy set of APIs to work which I use quite a lot.

Ge Ambassador Mark Ii Manual here. It allows you to call an external executable and wait until it is finished before moving on to the next line of my code.