Bartender Printing Empty Rows - Excel S’abonner

0
Avatar
Legacy Poster

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 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

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
Avatar
Shotaro Ito
Actions pour les commentaires Permalien

Interesting challenge..
Perhaps BarTender reads blank rows.
Try setup Query in BarTender's database connection setup - condition like "Field1" Not= "NULL".
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

[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.

Jessy
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

[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.

Jessy

Vous devez vous connecter pour laisser un commentaire.