print from excel to bartender

[masterx7]

hi

I need to print directly from excel to bartender.
I found some code, but I get error.

http://prntscr.com/j04ztz

this is my code

Private Sub CommandButton1_Click()


Dim btApp As BarTender.Application
Dim btFormat As BarTender.Format
Dim btSubString As BarTender.SubString


Set btApp = New BarTender.Application
Set btFormat = btApp.Formats.Open("c:\bartenderfile.btw")
btApp.Visible = False
btFormat.SetNamedSubStringValue "Part", Filename

End Sub

 

[masterx7]

Help anyone?

 

[shg]

Have you set a reference to BarTender?

 

[shg]

For anything specific to BarTender, you might have more success on their support site.