Bartender Vba Print Command Follow

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 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

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
Comment actions Permalink

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
Comment actions Permalink

 I think something like collate in Wordpad print options.
 
 Piotr
0
Avatar
Legacy Poster
Comment actions Permalink

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
Moderator
Comment actions Permalink

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.

Please sign in to leave a comment.