Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Version Control 2003 vs 2007 Iona Excel Discussion (Misc queries) 1 February 4th 09 08:07 PM
hyperterminal, excel, and MSComm Andrew[_56_] Excel Programming 2 January 19th 09 01:44 PM
Excel 2007 vs. 2003 VBA Control Questions Ondy2112 Excel Discussion (Misc queries) 3 May 29th 07 10:41 PM
Help with MSCOMM control EAB1977 Excel Programming 0 December 28th 05 07:43 PM
Loading MSComm.vbx into Excel VB ryan Excel Programming 0 August 10th 03 06:17 PM


All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"