Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MSCOMM Control in Excel 2003 / 2007
Is the MSCOMM control still available in Excel 2003 and 2007?
I see little published about it here lately. My application is a simple RX / TX monitor with no hardware handshaking. If anyone can share code/experiences I would appreciate it. Regards, TomC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MSCOMM Control in Excel 2003 / 2007
You can still use in XP below. Not sure about vista. Open "com1" For Input As #1 Most people are using network connections over IP which are much faster. Most PC these days don't even have serial ports or printer ports. You can even use your USB ports for communications. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147530 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MSCOMM Control in Excel 2003 / 2007
On Oct 24, 9:29*am, joel wrote:
You can still use in XP below. *Not sure about vista. Open "com1" For Input As #1 Most people are using network connections over IP which are much faster. *Most PC these days don't even have serial ports or printer ports. *You can even use your USB ports for communications. -- joel ------------------------------------------------------------------------ joel's Profile:http://www.thecodecage.com/forumz/member.php?userid=229 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=147530 Thanks Joel. My application is communication with a simple embedded system which has only a RS232 port. Thus, it certainly does not have TCP IP. USB communications with embedded systems is considerably more complex than RS232, and in most cases impossible as the supplier of the USB interface circuit must supply the relevant drivers. I am using a USB to serial convertor on a WinXP system. As RS232 is a simple, non-supplier specific, all small / embedded systems support it at a very elemental level. Thanks again and regards, TomC |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MSCOMM Control in Excel 2003 / 2007
The control should still be available although it wont work in 2010 64bit
Can put in on a sheet or form, in the ActiveX controls toolbox toolbar or Userform's toolbox, add as an additional control "Microsoft Winsock control". If you get a security message when adding it to the form or sheet, or it doesn't appear, see this link and get the update (your users will need to do same) http://support.microsoft.com/kb/827742 Regards, Peter T "tomcee" wrote in message ... Is the MSCOMM control still available in Excel 2003 and 2007? I see little published about it here lately. My application is a simple RX / TX monitor with no hardware handshaking. If anyone can share code/experiences I would appreciate it. Regards, TomC |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
MSCOMM Control in Excel 2003 / 2007
Hasn't microsoft realized they are going to need to support the system32 folder in 2010. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147530 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Version Control 2003 vs 2007 | Excel Discussion (Misc queries) | |||
hyperterminal, excel, and MSComm | Excel Programming | |||
Excel 2007 vs. 2003 VBA Control Questions | Excel Discussion (Misc queries) | |||
Help with MSCOMM control | Excel Programming | |||
Loading MSComm.vbx into Excel VB | Excel Programming |