Control of comm port using Excel

M

Thread Starter

Malcolm Noble

I wish to send simple on/off commands to a relay controller via the serial port using data in an Excel column. Do I need to install VB6 to do this or can I do it from the application (excel) visual basic?
 
VB6 is not required, just MSCOMM32.ocx and it's associated license file (or any other equivalent serial comm port ActiveX control). You should be able to plunk it down on the worksheet and then use VBA (i.e. macros) to call MSCOMM32.
 
What are API calls, and can u explain me about database connectivity between s7-200plc (siemens)
and VB -6.0
 
A
hi,
it is possible if you install VB 6 and add mscomm control object (ocx) into your VBA form.
regards
anoop
 
Top