2,462
社区成员
发帖
与我相关
我的任务
分享
Sub 自动截图()
'
' 自动截图 宏
'
'
Windows("JPInstantSLA-20190702.xlsm").Activate
Sheets("INT SLA Dashboard").Select
Range("A33:H55").Select
Dim time As String
time = CStr(Now())
Selection.Copy
Application.CutCopyMode = False
If Application.Wait(Now + TimeValue("0:00:2")) Then
Dim u As Integer
u = 1
End If
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
Application.CutCopyMode = False
If Application.Wait(Now + TimeValue("0:00:2")) Then
u = 1
End If
Range("a1").Select
ActiveSheet.Paste
Set Newshape = ActiveSheet.Shapes(ActiveSheet.Shapes.Count)
With ActiveSheet.ChartObjects.Add(1, 1, 1, 1)
.Width = Newshape.Width
.Height = Newshape.Height
Newshape.Copy
.Select
.Chart.Paste
.Chart.Export ActiveWorkbook.Path & "\" & Cells(34, 12) & ".jpg"
.Delete
End With
Newshape.Delete
End Sub