Hi, Thanks for your answer. You're right and actually the main issue is about static classes (like AdWordsService.v201109_1.CreateAccountService) that are not handled by COM and VBA.
Your solution will certainly work, and should be not to hard to code (I'm not a .NET developer, but it seems reachable). Thanks, - DB. Le mardi 22 mai 2012 16:21:33 UTC+2, Anash P. Oommen a écrit : > > Hi, > > I've never tried doing com interop with the AdWords API .NET library, but > I think you will have better chances of making it work if you were to write > a simple com-interop utility library in VB.NET/C# that uses the client > library to perform tasks and call that utility library from VBA. If you use > the library as such, I suspect you will have issues when VBA tries to call > overloaded constructors, methods, etc. VBA isn't as object-oriented as > VB.NET. > > See http://jumbloid.blogspot.in/2009/12/making-net-dll-com-visible.html for > details on how to write a comvisible assembly. > > Cheers, > Anash P. Oommen, > AdWords API Advisor. > > On Sunday, 20 May 2012 23:34:06 UTC+5:30, groucho wrote: >> >> Hi all, >> >> Another question concerning VBA access to Adwords API in the forum. I >> hope I could write a complete walkthrough for VBA user after that. >> >> I've recompiled the Common and Adwords librairies with COM visibility, >> and trying to make a simple AccountCreation example conversion from VB to >> VBA but I can't (don't know more exactly) how to call from VBA the >> ServiceSignature AdWordsService.v201109_1.CreateAccountService. I >> believe it's more a VB2VBA language conversion problem (object >> instantiation) than a API issue. >> >> Private Sub CommandButton1_Click() >> >> Dim user As Google_AdWords.AdWordsUser >> >> Set user = New Google_AdWords.AdWordsUser >> >> ' Get the CreateAccountService. >> Dim createAccountService As >> Google_AdWords.Google_Api_Ads_AdWords_v201109_1_CreateAccountService >> >> Set createAccountService = user.GetService(...) >> >> The original code is : >> >> Dim createAccountService As CreateAccountService = user.GetService( >> _ >> AdWordsService.v201109_1.CreateAccountService) >> >> Does anyone know how to go from the VB to the VBA code ? >> >> Very precise question, but it seems to be my last issue before using >> adwords api from VBA (Excel, Access)... >> >> Thanks for your help ! >> >> - DB. >> > -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
