Bartender 7.0 Activex Can't Create Object S’abonner

0
Avatar
Legacy Poster

Hello,

I am returning to do some VBA automation in Excel with Bartender 7.0 Professional

 

I added Bartend.exe to References and it showup as Check and BarTender 7.0.

 

It also shows up in Object Browser.

 

However, when I run the short macro below I get an "ActiveX component Can't Create Object"

 

What am I missing?

 

Thanks for you help.

 

 

Sub Button4_Click()
Dim btapp As BarTender.Application
Set btapp = CreateObject("Bartender.Application")
btapp.Visible = True
bt_Loaded = True

End Sub

5 commentaires

0
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

Your code looks correct to me. Just in case, I've attached an example of automating BarTender through ActiveX from Access. Please rename the .txt to .zip and unzip the files. Does this sample work for you?

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Thanks so much for your fast reply. Did not work, with the same error. Leads me to believe it is my installation that went wrong. I am going to download the trial version and see if I can make it work there (I think ActiveX works in trial). If it does, I know it is my installation of 7.0 that is not right.

Thanks again,

Jens

0
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

Yes, please give it a try. During the first 30 Trial days automation will be supported.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Yes, it worked in version 10! I guess it's time to upgrade!

Thanks again for your help.

0
Avatar
Michael Toupin (mtoupin
Actions pour les commentaires Permalien

just FYI it didn't work in 7.0 because you need the enterprise edition of 7.0 to do automation.  It's not the installation, it's just the fact that the edition you're using doesn't support it.

Vous devez vous connecter pour laisser un commentaire.