Printing using Excel VBA 追蹤
Iam trying to write a VBA code that allows labels to be printed from an excel sheet . I have done the following
1. Designed a label format in bartender
2. Create a named data source for each piece of information that needs to be printed on a label
3. Wrote the following VBA code
Set btApp = New BarTender.Application
Set btFormat = New BarTender.Format
btApp.VisibleWindows = btNone
Set btFormat = btApp.Formats.Open("D:\Supreme Logistics\test
program\testlabel.btw", False, "")
Beyond this I do not know how to write a code that picks each row from the sheet and creates a label.
How do I create a code that loops within a range of records and prints each row as a label ?