|
本帖最后由 hwc2ycy 于 2012-12-5 13:31 编辑
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim Path$, filename$
- On Error Resume Next
- If Targetrow < 5000 And Target.Column < 2 Then
- Range("T2") = Cells(Target.Row, Target.Column)
- End If
- Worksheets("准考证").DrawingObjects.Delete
-
- Path = ThisWorkbook.Path & "\pic" & [t2] & ".jpg"
- filename = Dir(Path, vbNormal + vbDirectory + vbHidden + vbReadOnly + vbSystem)
- If Len(filename) > 0 Then
- With Worksheets("准考证")
- With .Pictures.Insert(Path)
- .ShapeRange.Left = 340
- .ShapeRange.Top = 80
- .ShapeRange.Height = 140
- .ShapeRange.Width = 110
- End With
- With .Pictures.Insert(Path)
- .ShapeRange.Left = 340
- .ShapeRange.Top = 465
- .ShapeRange.Height = 140
- .ShapeRange.Width = 110
- End With
- .PrintPreview
- If MsgBox("确定要打印吗?", vbOKCancel, "打印") = 1 Then .PrintOut: DoEvents
-
- End With
- End If
- End Sub
复制代码 原来的改进版,点的时候可以选。呆会再帮你做一个批量打印。 |
|