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
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
0
-
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. 0 -
Shotaro Ito
★ BarTender Hero ★
Interesting challenge..
Perhaps BarTender reads blank rows.
Try setup Query in BarTender's database connection setup - condition like "Field1" Not= "NULL".0 -
[quote name='nRyder' timestamp='1340141412' post='2640']
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.
Jessy0 -
[quote name='Shotaro I -Seagull Support' timestamp='1340167220' post='2642']
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.
Jessy0
Please sign in to leave a comment.
Comments
4 comments