Bartender Vba Print Command
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
-
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 -
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 PrintLook 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 -
I think something like collate in Wordpad print options.Piotr0
-
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 -
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.
0
Please sign in to leave a comment.
Comments
5 comments