[SOLVED] Help with using an activex control

Hello,
I am trying to use the Microsoft communications control 6.0
(MSCOMM32.ocx).
To use it under VBA in Excel i have to create the ActiveX module
somehow.
I neeed to create the object in my worksheet first so that i can double
click it and write the code in VBA.
It seems that this should be as easy as dragging and dropping a
commandbutton. However when I select the "Microsoft communications
control 6.0" under the "more Control Elements" button i get an error
message saying "object could not be created". I get this same message
for some but not all of the other activex controlls too. (desperately
tryign to create all kinds of elements hoping to find a solution)

I know there is an easy 30 sec way to do this but i am stuck in my
ways. Please help!
Goodnight (2.30am)

Try putting it on a userform.

--
Regards,
Tom Ogilvy


"CrazyPhilll" wrote:

> Hello,
> I am trying to use the Microsoft communications control 6.0
> (MSCOMM32.ocx).
> To use it under VBA in Excel i have to create the ActiveX module
> somehow.
> I neeed to create the object in my worksheet first so that i can double
> click it and write the code in VBA.
> It seems that this should be as easy as dragging and dropping a
> commandbutton. However when I select the "Microsoft communications
> control 6.0" under the "more Control Elements" button i get an error
> message saying "object could not be created". I get this same message
> for some but not all of the other activex controlls too. (desperately
> tryign to create all kinds of elements hoping to find a solution)
>
> I know there is an easy 30 sec way to do this but i am stuck in my
> ways. Please help!
> Goodnight (2.30am)
>
>

Good morning,

Somewhat to my surprise I found I could add that control to a worksheet.
Clicked the more controls on the control Toolbox menu, found it and it went
straight on. But not onto the toolbar and only after a couple of attempts.

Doubled clicked the already selected phone icon object and it popped this
into the sheet module

Private Sub MSComm1_OnComm()
End Sub

Other events are GotFocus & LostFocus.

I wouldn't know what to do with it though, but in another sub in the
worksheet module I did this

Dim m As MSComm
Set m = MSComm1
Stop ' alt-v s

seems to be plenty there in the Locals window.

When I exit/enter design mode the object becomes invisible/visible.

Regards,
Peter T

"CrazyPhilll" <Philippklaschka@yahoo.com> wrote in message
news:1145611440.518831.61740@v46g2000cwv.googlegroups.com...
> Hello,
> I am trying to use the Microsoft communications control 6.0
> (MSCOMM32.ocx).
> To use it under VBA in Excel i have to create the ActiveX module
> somehow.
> I neeed to create the object in my worksheet first so that i can double
> click it and write the code in VBA.
> It seems that this should be as easy as dragging and dropping a
> commandbutton. However when I select the "Microsoft communications
> control 6.0" under the "more Control Elements" button i get an error
> message saying "object could not be created". I get this same message
> for some but not all of the other activex controlls too. (desperately
> tryign to create all kinds of elements hoping to find a solution)
>
> I know there is an easy 30 sec way to do this but i am stuck in my
> ways. Please help!
> Goodnight (2.30am)
>

Peter T : that is exactly the part that doesnt work .... I clicked the
more controls on the control toolbar and selected it. Then when
clicking onto the worksheet the error message pops: "Cannot insert
object"
what to do?

Don't know!
Just tried again no problem. Having selected it in the list need to "draw"
it onto the sheet - did you try that.

Long shot, try adding the ref in Tools References first
Microsoft Comm Control 6.0

I didn't need to do that, it got added automatically.

If stuck I can send to a workbook with the control embedded on a sheet, but
don't ask me what to do with it !

Regards,
Peter T

"CrazyPhilll" <Philippklaschka@yahoo.com> wrote in message
news:1145639492.318454.132420@g10g2000cwb.googlegroups.com...
> Peter T : that is exactly the part that doesnt work .... I clicked the
> more controls on the control toolbar and selected it. Then when
> clicking onto the worksheet the error message pops: "Cannot insert
> object"
> what to do?
>

Peter T:
yeah, the cursor changes to a little crosshair and i can draw a box
..... once i release the left or right mousbutton (wichever i draw the
box with) the error message mentioned above pops up.
Microsoft Comm Control 6.0 is already added under references in VBA.

As you can set the reference can you add it with code

Sub test()
'this in a sheet module hence "Me"
Dim oleObj As OLEObject
Dim m As MSComm

Me.OLEObjects.Add ("MSCOMMLib.MSComm.1")
Set oleObj = Me.OLEObjects(1)
Set m = oleObj.Object

Debug.Print oleObj.Name ' MSComm1
Debug.Print m.ProgId ' MSCOMMLib.MSComm.1
End Sub

Regards,
Peter T


"CrazyPhilll" <Philippklaschka@yahoo.com> wrote in message
news:1145641554.868117.74330@i39g2000cwa.googlegroups.com...
> Peter T:
> yeah, the cursor changes to a little crosshair and i can draw a box
> .... once i release the left or right mousbutton (wichever i draw the
> box with) the error message mentioned above pops up.
> Microsoft Comm Control 6.0 is already added under references in VBA.
>