I recently purchased a Brother QL-570 label printer, unfortunately it doesn't operate when I try to use VBA samples provided by Brother:
I've made sure to included the b-Pac reference library in Excel VBA.
Please Login or Register to view this content.
I've also stepped through the code, no errors occur. Any suggestions on how I could get this to work?
Hello sdfryc,
I suspect your problem lies within these 2 lines:
The Dim statement is used to declare an object variable of the type bpac.Document. This statement will only work with Early Binding which means the object library has been loaded. In your case, this would be true since you said, "I've made sure to included the b-Pac reference library in Excel VBA. "Please Login or Register to view this content.
The CreateObject statement is used to load an object library and instantiate the object at run-time. This is referred to as Late Binding.
Try changing this statement to...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello sdfryc,
I suspect your problem lies within these 2 lines:
The Dim statement is used to declare an object variable of the type bpac.Document. This statement will only work with Early Binding which means the object library has been loaded. In your case, this would be true since you said, "I've made sure to included the b-Pac reference library in Excel VBA. "Please Login or Register to view this content.
The CreateObject statement is used to load an object library and instantiate the object at run-time. This is referred to as Late Binding.
Try changing this statement to...
Please Login or Register to view this content.
Hi Leith,
Thanks for your suggestion. I tried changing the statement, unfortunately it creates a Compile Error:
Compile Error.JPG
Regards,
Simon
Since you're using Option Explicit () this means that you didn't declare your objDoc with a Dim statement.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi bakerman2,
I've tried removing Option Explicit which didn't help.
I've also tried keeping Option Explicit and declaring the objDoc with a Dim statement, this allows the code to run but still doesn't operate the printer.
Hi Comunity:
The solution that works for me, is in vba ribbon check references:
Brother b-pac 32 type Library (activate)
The problem was excel vba dll not operative
Greets
Attachment 753566
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks