Automation Error 440
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?
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?
0
-
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.pdf0 -
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 -
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 -
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...0
Please sign in to leave a comment.
Comments
4 comments