I am trying to open com1 in vb and get data from a tag reader as the tags are
read. I have started with this

Private Sub Worksheet_Activate()

' Open the serial port
MSComm1.CommPort = 1
MSComm1.Settings = "115200,N,8,1"
MSComm1.PortOpen = True

but it is giving me an error straight up. Do I need to download anything for
the MSComm1 commands to work. I realise I would need to put in loops etc for
it to continually monitor the port but I can't even get it to open the port
yet.

Thanks