Bartender 7.0 Activex Can't Create Object 追蹤

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 意見

0
Avatar
Domingo Rodriguez
版主
評論操作 永久連結

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
評論操作 永久連結

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
版主
評論操作 永久連結

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

0
Avatar
Legacy Poster
評論操作 永久連結

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

Thanks again for your help.

0
Avatar
Michael Toupin (mtoupin
評論操作 永久連結

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.

登入寫評論。