Using VBA in Excel to print to Brother Label Printer

[SpacemanSpiff]

Hi all...

Crazy problem here. I have a new QL-700 label printer that purports to allow printing from VBA, .Net and such... and comes with example files.

Running from Excel, their example code never works... at least not right off.

They have two versions of the SDK... 32 and 64 bit.

I got it to work finally on my Win 10 machine with Excel 2016 (Pro Plus)... by adding what they call the "Client Component"... which seems to point toward a Reference: "Brother b-PAC 3.1 Type Library".

The Component appears to install the 32 bit version of the libraries, because they are stored under the Program Files (x86) structure.

The SDK (which needs to be the 64 bit version) also must be installed, and lives under the Program Files structure.



Things get ugly when I try to move this to a Windows 7 Machine... and Excel 2010.

It simply refuses to work... and fails silently, even using the Brother example code.

One issue may be that for some reason, the 64 bit SDK ALWAYS asserts itself over the 32 bit version that comes with the Client Component. Even when I see the Client Component in the References list in the x86 installation, selecting it in the VBA IDE magically transforms it into the 64 bit install.

Perhaps it's a conflict between a 64 bit OS, and a 32 bit Excel?

I have no idea what to do at this point... I don't really understand it much.

Hours of Google searches have yielded no working solutions.

Any thoughts / ideas greatly appreciated.

[westconn1]

did you find this one
http://stackoverflow.com/questions/2...ailed-to-print

[SpacemanSpiff]

did you find this one
http://stackoverflow.com/questions/2...ailed-to-print

Yes I did... That description if of an issue that causes an error... in my case, it fails silently.

[westconn1]

try unregistering (or uninstalling) the 64 bit version, on machines where office is 32 bit, it clearly states the 64bit version only works with 64 bit applications regardless of OS

[SpacemanSpiff]

try unregistering (or uninstalling) the 64 bit version, on machines where office is 32 bit, it clearly states the 64bit version only works with 64 bit applications regardless of OS

Right, the code failes. "Application error. The specified module could not be found."

    Dim ObjDoc As bpac.Document  
    Set ObjDoc = CreateObject("bpac.Document")  '<--- FAILS

To be clear, this is when the 64 bit is uninstalled... and only the 32 bit and "client component" are installed.

I'm not clear on what the error message is telling me.

[westconn1]

i will try to have a play with this later, i do have a ql printer, but i have never automated its use