Bartender Printing Empty Rows - Excel 关注
Hi,
I set up a template excel document which uses macros to fill and clear itself. The goal was to link my bartender document to this unique excel document, so I could fill my first page, run the macro to fill the page that bartender sees, save, open bartender, print and then clear my worksheet with a macro for the next use (I used the clearcontents function in vba just to ensure that my cells would be empty, because I noticed that bt does not * usually* consider them) .
It seemed simple to use until I tested it.
I tested at first with 6000 rows. It worked fine, it printed 6000 stickers.
When I tried it again, this time with 2000 rows, bt still considered 6000 rows. Even though the last 4000 rows were empty.
How do I fix this?
Why does it do that?
Thanks for the help!
Jessy
4 评论
Perhaps BarTender reads blank rows.
Try setup Query in BarTender's database connection setup - condition like "Field1" Not= "NULL".
Well, you can specify if your print prompt record selection to only print records 1-2000. Or you can copy and paste your data out of your current Excel into a new one. Sometimes it gets confused and thinks your cells without data in them are still part of the database.
[/quote]
Thanks for the info! I do prefer the automatic way, but I'll use what you said one day for sure! Thanks for your time.
Jessy
Interesting challenge..
Perhaps BarTender reads blank rows.
Try setup Query in BarTender's database connection setup - condition like "Field1" Not= "NULL".
[/quote]
It works perfect now! Big thanks for that one.
Jessy
请先登录再写评论。