Bartender 7.0 Activex Can't Create Object
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
-
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 -
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 -
Yes, please give it a try. During the first 30 Trial days automation will be supported.
0 -
Yes, it worked in version 10! I guess it's time to upgrade!
Thanks again for your help.
0 -
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.
0
Please sign in to leave a comment.
Comments
5 comments