|
本帖最后由 苏子龙 于 2017-3-3 10:30 编辑
另做了个excel打印代码,是否满足要求,代码后改动了一点,看附件- Sub printpz()
- Dim arr, i%, ks%, js%, ph$, TpNm$
- Dim tp As Shape
- ks = [j1]: js = [j2]
- ph = ThisWorkbook.Path & ""
- ActiveSheet.PageSetup.PrintArea = Range("a1:c3").Address '打印区域
- arr = Sheet1.UsedRange
- For i = 2 To UBound(arr)
- If i > js Then Exit Sub '条件判断
- If ks > js Then MsgBox "请检查开始页是否正确"
- For Each tp In Shapes '删除已有图片
- If tp.Top = Range("a3").Top And tp.Left = Range("a3").Left Then tp.Delete
- Next
- If i >= ks Then
- [b1] = arr(i, 1)
- If Dir(ph & arr(i, 1) & ".*") <> "" Then
- TpNm = Dir(ph & arr(i, 1) & ".*")
- With Range("a3:c3") '插入图片
- Me.Shapes.AddPicture Filename:=ph & TpNm, LinkToFile:=True, SaveWithDocument:=False, _
- Left:=.Left, Top:=.Top, Width:=.Width, Height:=.Height
- End With
- Else
- Range("a3:c3") = "无此凭证图片"
- End If
- End If
- ActiveSheet.PrintOut '打印
- Next
- End Sub
复制代码 |
|