|
Private Sub CommandButton1_Click()
Dim i%
If [f3] > [f4] Then MsgBox "起始必须小于结束!": [f3] = "": [f4] = "": Exit Sub
Dim intr As Integer
intr = MsgBox("认真检查起始序号和结束序号,确定要打印吗?", vbYesNo + vbQuestion, "提示")
If intr = vbYes Then
For i = [f3] To [f4]
With Sheets("Sheet2")
[Sheet1!c5] = .Cells(i + 6, 2)
[Sheet1!f7] = .Cells(i + 6, 3)
[Sheet1!c7] = .Cells(i + 6, 4)
[Sheet1!f5] = .Cells(i + 6, 5)
[Sheet1!c9] = .Cells(i + 6, 6) & "元"
[Sheet1!c10] = .Cells(i + 6, 7)
[Sheet1!c11] = .Cells(i + 6, 8)
fs1 = ThisWorkbook.Path & "\产品图片\" & .Cells(i + 6, 2) & ".jpg"
If Dir(fs1) <> "" Then
Sheet1.Select
Sheet1.Range("f9:f11").Select
ActiveSheet.Pictures.Insert(fs1).Select
With Selection.ShapeRange
Selection.ShapeRange.LockAspectRatio = msoFalse
.Top = Sheet1.Range("f9:f11").Top + 1
.Left = Sheet1.Range("f9:f11").Left + 1
.Width = Sheet1.Range("f9:f11").Width
.Height = Sheet1.Range("f9:f11").Height
End With
End If
End With
Sheet1.PrintOut
For Each s In Sheet1.Pictures
s.Delete
Next s
Next i
End If
End Sub
|
|