Beatricz-
Are you a registered developer at Developer.Skype.com? If so, perhaps you can contact their support. All the examples I found on their website show embedding a call within Java or HTML. It may not be possible to call Skype from VBA.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of emmanuelbeatrice@hotmail.com
Sent: Sunday, December 01, 2013 3:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: [MS_AccessPros] RE: Run-Time Error '429': ActiveX component cannot create object
Hi John,
In the Available References Windows under 'Tools' >>> 'References' What I see being currently referred is called 'Skype4COM 1.0 Type Library' and this is a .dll file called 'Skype4COM.dll
In the Object Browser of VBA Editor, when I search for 'Skype4COM'- there is no result. However, when I search for 'Skype4COMLib'- all the members of that object shows up.
What I downloaded is Skype4COM-1.0.33 zip folder (were the .dll file and the .exe are included).
What shows up in VBA editor's intellisense once I declare an object variable of type 'Skype4COMLib' are all the members of that class. However, the run-time error 429 pops up at one point.
If I try to declare an object variable of type 'Skype4COM' only, it doesn't expose any members in intellisense.
What seems to occur is the library that currently gets referenced, namely, 'Skype4COMLib' can't create activeX object, hence the run-time error 429- however, the library that I want, namely, 'Skype4COM' is not being referenced for whatever reason...
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote:
Beatricz-
Is Skype4COMLib the name of the library or the name of the object? That looks like a library name.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of emmanuelbeatrice@...
Sent: Saturday, November 30, 2013 11:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: Run-Time Error '429': ActiveX component cannot create object
Hi John,
yes I have load up skype object from the start- - when i look into the object browser, as you suggested, "Skype4COMLib" shows up but "Skype4COM" doesn't-- i am not sure if they are one or the same- but the one that shows up on the object browser (|Skype4COMLib) still gives me the run-time '429' error. So,I'm stuck either way.
thanks in advance.
Beatricz
---In ms_access_professionals@yahoogroups.com, <JohnV@...> wrote:
Beatricz-
Did you load the Skype library in Tools / References? If yes, then when you use the Object Browser on that library, does it show a Skype object? If not, then that's your problem.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of emmanuelbeatrice@...
Sent: Saturday, November 30, 2013 7:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: [MS_AccessPros] Run-Time Error '429': ActiveX component cannot create object
Hi John.
I did have an object reference in vba through tool menu.As you suggested, I've checked on regedit and the library is there with a key.
The problem is two-fold: First of all, I cannot declare and compile successfully with 'Skype4COM.Skype;- it tells me that 'user-defined type not define' message even though Skype4COM is properly referenced and registered. Second of all, when I declare with 'Skype4COMLib.Skype', it compiles just fine and the objects show in the vba intellisense, however, i get the run-time error 429.
the following code-declare, compile successfully and objects are visible in intellisense but it gives me the run-time error '429'
Dim oSkype As SKYPE4COMLib.Skype
Dim oCall As SKYPE4COMLib.Call
Dim oCon As SKYPE4COMLib.Conference
Set oSkype = New SKYPE4COMLib.Skype
If Not oSkype.Client.IsRunning Then
oSkype.Client.Start
End If
this code does't declare and compile successfully and gives me the message 'user-defined type not defined':
Dim objSkype As Skype4Com.Skype
Set objSkype = New Skype4Com.Skype
it tells me that 'user-defined type not defined'
What else, in your opinion, could be done to overcome this hurdle?
Thanks,
Beatricz
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote:
Beatrice-
For VBA to be able to "see" an object like "Skype4COM.Skype", the dll must be registered in Windows. Try using Regsvr32.
http://stackoverflow.com/questions/4897685/how-do-i-register-a-dll-on-windows-7-64-bit
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of emmanuelbeatrice@...
Sent: Friday, November 29, 2013 5:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Run-Time Error '429': ActiveX component cannot create object
Hi, I am trying to use Skype4COM api to handle my callings in access database. and i have done all the proper .dll registrations and object referencing. However, each time the compiler gets to the line: 'Set oskype = CreateObject("Skype4COM.Skype")', it gives me the '429' run time error- no matter whatever way - declare the object. I am using MS Access 2013, both 64-bits. here below is a sample of my code. I ran out of possible troubleshooting ideas on what may cause this run-time error. thank you in advance, Beatricz
Private Sub Call_Click()
Set oskype = CreateObject("Skype4COM.Skype")
If Not oskype.Client.IsRunning Then
oskype.Client.Start
End If
Set oUser = oskype.User("User1")
Set oCall = oskype.PlaceCall(me.Number)
End Sub
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar