About Us

TomCee

On Feb 26, 10:42*pm, tomcee wrote:
On Feb 25, 9:20*pm, tomcee wrote:

On Feb 24, 8:46*pm, tomcee wrote:

On Feb 20, 11:30*am, tomcee wrote:

On Feb 20, 10:38*am, tomcee wrote:

I am experiencing very strange behaviour with the MScomm32 control in
Excel 2003 VBA.

The control is registered, and I can install it in my spreadsheet, but
when running (via Sub Worksheet Change), it appears to execute once (I
have a Belkin USB/RS232 adaptor which has status and TX/RX LEDs).

On successive executions, I get error messages that the port is
already open (I do set the PortOpen property to False at the end of
each run), but if I do not execute the .portopen to true, it returns
an error saying the port is not open!).

I am using MSCOMM32.ocx version 7-26-95, I believe installed with my
VB4.

Also, I notice that when I exit Excel, the status LED on the USB/RS232
adaptor blinks.

It seems to me that there is some setting in the com port status that
I am not maintaining or Set/resetting in the correct order.

Thanks in advance for your assistance!
TomC
--------------------------------------------------------

Here is my code:
[obviously with some commented remnants of my failed attempts.]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MSComm1.Enabled = True
'MSComm1.PortOpen = False
MSComm1.Activate
'MSComm1.PortOpen = False
'MSComm1.PortOpen = False
MSComm1.PortOpen = True
MSComm1.Settings = "9600,N,8,1"
MSComm1.Handshaking = NoHandshaking

'MSComm1.PortOpen = True
MSComm1.Output = "Hello out there!"
MSComm1.PortOpen = False
'MSComm1.Delete

End Sub

Fwiw:

I found that my VB4 has the same issue!!!

So, I installed this mscomm32.ocx:
===========================
mscomm32.ocx 103744 6-24-98

and registered it via:
regsvr32 c:\windows\system32\mscomm32.ocx

and things seem to work fine in Excel2003 !!!

It also fixed the issue in VB4!!!

It appears that there was a port close issue with the older
mscomm32.ocx that I was using!

Cheers!!TomC- Hide quoted text -

- Show quoted text -

So,....a few days ago, things were working fine.

Today when I try to open this excel sheet, I get an error message that
says,"Can't exit design mode because control MSCOMM1 can not be
created'.

So now I no longer can access the serial ports!!!

I've tried re-registering the control, both through Excel and from the
Run prompt.

Anyone have an idea what is going on?

Thanks in advance!TomC- Hide quoted text -

- Show quoted text -

I suspect some strange problem between Excel 2003 and the mscomm
contol I was using.

I'm puzzled why it had worked for a while and then would not work. *Is
my registry perhaps corrupted?

Any ideas?

TIA,tomc- Hide quoted text -

- Show quoted text -

Any help? *If I should post this in a different group, please let me
know!

Thanks,TomC- Hide quoted text -

- Show quoted text -

Any help? Please?

TomC

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003: Control tab in "Format Control" doesn't show up.	Tom Ogilvy	Excel Programming	0	January 19th 07 12:22 AM
Excel 2003: Control tab in "Format Control" doesn't show up.	Dave Peterson	Excel Programming	0	January 18th 07 08:02 PM
MSCOMM32 Control	Mark Ivey	Excel Programming	6	July 30th 06 03:49 AM
MSComm32	Axehandler	Excel Programming	0	October 11th 04 12:44 AM
serial port mscomm32.ocx in excel	Brian	Excel Programming	0	July 25th 03 11:22 PM

Menu

About Us