Anyone Help Me With Basic Label Print From Script Follow
I'm searching high and low for examples of printing from Excel vba or vbscript; dont care as long as I can find one that works.
All I seem to be finding, are examples that don't work.
I did find one example that works, but need to expand on how I send data to a variable in the label.
Below prints a label I designed with 1 text field. I populated the field with "test". The label prints with the code below.
Dim btApp As BarTender.Application
Dim btFormat As BarTender.Format
Set btApp = New BarTender.Application
Set btFormat = New BarTender.Format
btApp.Visible = True
btApp.ActiveFormat.IdenticalCopiesOfLabel = 6
btFormats = btApp.ActiveFormat.PrintOut(False, False)
In other examples I've seen:
'Set the ProductName substring data
btFormat.SetNamedSubStringValue("test", "Fruit Loops")
But when I copy this line into excel vba, it errors out; Compile error, expected =.
VBA shows the example methood for handling this line as:
SetNamedSubStringValue(SubStringName As String, Value As String)
I'm confused and would be greateful if someonw could help me move past this
Please sign in to leave a comment.