Automation Error 440 S’abonner

0

Hello all! my first post on the forum :)

I have a small excel macro I wrote to print a label after reading a barcode with a scanner. I have tried it and its working fine on one computer, however I want to use it on another computer and I get a pestering run time Automation error(440) when the code tries to open a BarTender.Application.

I noticed that this other computer did not have bartender on its reference list, although bartender is installed! So I browsed for the bartend.exe and added it. The code recognizes bartender objects and everything but the error is still there!!!

What am I missing? :(

4 commentaires

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

What edition is the BarTender installed? If it's Basic or Professional it will not work as the Automation edition or above is needed to programmatically control BarTender.

If the edition is sufficient you could try re-registering the BarTender class on the system. Do this by opening a command prompt (DOS) windows, change directory to where BarTender is installed and run the following command line: bartend.exe /register

This should then make the BarTender class reference appear, so that it may be selected for your application.

The below white paper should also be helpful to you:

http://www.bartenderbarcodesoftware.com/label-software/whitepapers/Controlling-Barcode-Label-Software-using-ActiveX-Automation.pdf
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

The edition is 7.10 and I have it installed on both computers and it works fine on one of them. Ill try that on the other one!
0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

Note that v7.10 represents the version. The edition will be either Basic, Standard, Professional or Enterprise. Only the Enterprise edition supports the feature you are using.
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

It works! the vba code can now create bartender objects and print formats. Thanks!
Its strange that just the enterprise edition can work with vba, this macro I wrote seems pretty standard stuff...

Vous devez vous connecter pour laisser un commentaire.