Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.access.externaldata,microsoft.public.access.modulesdaovba,microsoft.public.access.modulesdaovba.ado,microsoft.public.excel.programming
|
|||
|
|||
probing the serial port for data
I've been told that it's possible to probe the serial port for data even
when you don't know the format of data that the device sends and receives. Has anyone done this in VBA? I have a Radio Shack PRO-95 scanner http://www.radioshack.com/product.as...uct%5Fid=20-52 5 It can store 1000 channels and is programmable through it's PC/IF port from a PC serial port. The cable looks like this: http://www.radioshack.com/images/Pro.../20/20-289.jpg The scanner has 10 banks and each bank can store 100 channels. The scanner can download and upload all its channels through its PC/IF jack to a PC serial port. I'd like to do this from Microsoft Access. There is a free program to do this at http://www.starrsoft.com/freeware/win95/default.asp and you can cut and paste columns of channels into Excel and Access, but I'd like to write my own application in Access and VBA so I can quickly reprogram my scanner without cutting and pasting to another program. Is there a way to do this in VBA without using addins? Jeff |
#2
Posted to microsoft.public.access.externaldata,microsoft.public.access.modulesdaovba,microsoft.public.access.modulesdaovba.ado,microsoft.public.excel.programming
|
|||
|
|||
probing the serial port for data
Tony Toews has some useful information about programming for the serial port
at http://www.granite.ab.ca/access/serialport.htm -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jeff" wrote in message news:g3Nsd.130220$SW3.78235@fed1read01... I've been told that it's possible to probe the serial port for data even when you don't know the format of data that the device sends and receives. Has anyone done this in VBA? I have a Radio Shack PRO-95 scanner http://www.radioshack.com/product.as...uct%5Fid=20-52 5 It can store 1000 channels and is programmable through it's PC/IF port from a PC serial port. The cable looks like this: http://www.radioshack.com/images/Pro.../20/20-289.jpg The scanner has 10 banks and each bank can store 100 channels. The scanner can download and upload all its channels through its PC/IF jack to a PC serial port. I'd like to do this from Microsoft Access. There is a free program to do this at http://www.starrsoft.com/freeware/win95/default.asp and you can cut and paste columns of channels into Excel and Access, but I'd like to write my own application in Access and VBA so I can quickly reprogram my scanner without cutting and pasting to another program. Is there a way to do this in VBA without using addins? Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Serial port interface | Excel Programming | |||
serial port data acquisition | Excel Programming | |||
Mac Serial Port Communication | Excel Programming | |||
Excel and the Serial Port | Excel Programming | |||
serial port mscomm32.ocx in excel | Excel Programming |