Bartender Vba Print Command S’abonner

0
Avatar
Legacy Poster

Is possible print label by VB command in BarTender with use Script Assistant -> Function and Subs.

 

I try command

 

Format.print

Format.printout

 

 

Best Regards

Piotr

 

 

 

5 commentaires

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

I suppose that if you're running an Automation edition or above you could execute a BarTender command line by calling the bartend.exe directly.  See the BarTender help system for a full reference on available command lines.  However, I would recommend you look into making use of the Integration Platform (or Commander for older versions) in order to achieve the end result that you're looking for.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Yes we have Automation edition but I don't want use Commander or start bartender.exe with parameters. I think somethink like hereunder.

 

One liners to Print

Look in the VBA help for PrintOut and see that you can use the following arguments.
expression.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName)

Note: Remember that you can't print sheets that are hidden. If you print the whole workbook with the first example there is no problem but the example for Sheets or worksheets (example 2 and 3) will not work if there are hidden sheets.

ActiveWorkbook.PrintOut
'the whole workbook

Worksheets.PrintOut
'all worksheets

Sheets.PrintOut
'all sheets

Sheets(Array("Sheet1", "Sheet3")).PrintOut
'all sheets in the array

ActiveWindow.SelectedSheets.PrintOut
'print all selected sheets

ActiveSheet.PrintOut
'only the activesheet

Sheets("Sheet1").PrintOut
'only "Sheet1"

Selection.PrintOut
'print only the selection

Range("C1:D5").PrintOut
'print range

 

=================================================

 

I have Excel document 

headline

value1

value2

value3

 

I can reprise value1, value2, value3 three times in Excel.

 

 

I want print out three copy value... but like that

value1

value2

value3

value1

value2

value3

value1

value2

value3

 

I can reprise value1, value2, value3 three times in Excel.

 

If I set three "Number of copies" in BarTender print option I get printout like that

value1

value1

value1

value2

value2

value2

value3

value3

value3

 

 

Best Regards

Piotr

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

 I think something like collate in Wordpad print options.
 
 Piotr
0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

I don't want insert 1-3;1-3;1-3  in Bartender's print window (what if i shout print out 1-3 thousand times ).

 

Piotr 

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

Create a batch file in Batch Maker specifying a repeat count for how many times you wish the print job to repeat.  A batch file can then be printed via the Print Station.

Vous devez vous connecter pour laisser un commentaire.