Excel Vba Serial Port Programming Code Someone Wrote
Excel Vba Serial Port Programming Software Can Be

For a better experience, please enable JavaScript in your browser before proceeding.

Excel Vba Serial Port Programming Software Can Be

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.

Excel Vba Serial Port Programming Code Someone Wrote

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.

Serial Port Communication in Excel (VBA) Electronics Open Source was the first place i found this code.

Else MsgBox Com Port Open Do While CommRead(intPortID, strData, 64) EOF datFeed datFeed strData Loop this is blank, no data colected, help MsgBox datFeed End If Call CommClose(intPortID) End Sub This is my call button.

We have a great community of people providing Excel help here, but the hosting costs are enormous.

You can help keep this site running by allowing ads on MrExcel.com.

Allow Ads at MrExcel Which adblocker are you using Disable AdBlock Follow these easy steps to disable AdBlock 1)Click on the icon in the browsers toolbar.

Click on the icon in the browsers toolbar.

Click on the Pause on this site option.

Go back Disable AdBlock Plus Follow these easy steps to disable AdBlock Plus 1)Click on the icon in the browsers toolbar.

Click on the toggle to disable it for mrexcel.com.

Go back Disable uBlock Origin Follow these easy steps to disable uBlock Origin 1)Click on the icon in the browsers toolbar.

Click on the Power button.

Click on the Refresh button.

Go back Disable uBlock Follow these easy steps to disable uBlock 1)Click on the icon in the browsers toolbar.