Excel Vba Printing 追蹤
I'm currently having an issue with my code in excel VBA. It seems like it would be relatively easy, but I cannot figure out the solution.
It involves printing to Bartender from a combo box drop down list. And while the list is working and shows my data, whatever code I seem to use prints all records of the database, rather than just the specific record that I have selected.
If there is someone who thinks they may be able to help me I would really appreciate it. I was reading on the forums somewhere it might have to do with "activeformat" but there was never a continuation of how to fix it or if that was for sure the reasoning.
Here is my code:
Dim BarTender As Object
Dim dirfile As String
dirfile = "something"
Dim btApp As BarTender.Application
Dim btFormat As BarTender.Format
Set btApp = New BarTender.Application
Set btFormat = New BarTender.Format
btApp.Visible = False
On Error Resume Next
If Range("B2").Value > 0 Then
For i = 1 To Range("B2").Value
btFormat.RecordRange = (WireLabelBox.LabelList)
btFormat = btApp.ActiveFormat.Printout (false, false) & i