Excel通过VBA打印信封:
Sub printSheet()
Dim no1 As Integer
Sheets("信封模板").Select '进入打印页面
no1 = 2
'no2 = InputBox("请输入打印内容行数:", "对话框", 1)
'If no2 = "" Then '如果在对话框中选择了取消按钮,则终止宏!
'Exit Sub
' End If
Do While no1 <= 65535
Dim isPrint As String
isPrint = Sheets("源数据").Range("m" + Trim(Str(no1 + 1))).Value
If isPrint <> "已打印" Then '判断此行是否已打印过打印过则跳过
Sheets("信封模板").Range("a1:f1").Value = Sheets("源数据").Range("a" + Trim(Str(no1 + 1)) + ":" + "f" + Trim(Str(no1 &
Excel通过VBA打印信封:
Sub printSheet()
Dim no1 As Integer
Sheets("信封模板").Select '进入打印页面
no1 = 2
'no2 = InputBox("请输入打印内容行数:", "对话框", 1)
'If no2 = "" Then '如果在对话框中选择了取消按钮,则终止宏!
'Exit Sub
' End If
Do While no1 <= 65535
Dim isPrint As String
isPrint = Sheets("源数据").Range("m" + Trim(Str(no1 + 1))).Value
If isPrint <> "已打印" Then '判断此行是否已打印过打印过则跳过
Sheets("信封模板").Range("a1:f1").Value = Sheets("源数据").Range("a" + Trim(Str(no1 + 1)) + ":" + "f" + Trim(Str(no1 &