如何把两个图表作为一个图片进行保存

fengye5200

Sub RunVBA()


        str_ThisFileParentPath = Pfld(ThisWorkbook.Path)
        'MsgBox str_ThisFileParentPath

    'Open RawData file
    On Error Resume Next
    ThisWorkbook.Worksheets("Retest at Wally").Activate
    Dim str_OpenRawData As Object
    Set str_OpenRawData = Workbooks.Open(filename:=Application.GetOpenFilename(",*.*"))
    'MsgBox "err" & Err
    If Err = 1004 Then
        MsgBox "Not open Raw Data file 没有打开原始数据"
        End
    End If
    str_OpenRawData_FullName = str_OpenRawData.FullName
    str_OpenRawData_Name = str_OpenRawData.Name
    'MsgBox str_OpenRawData.FullName

    str_ChartName = Left(str_OpenRawData_Name, Len(str_OpenRawData_Name) - 4)
    str_ChartNameb = str_ChartName & "_b"
    'MsgBox "aaa" & str_ChartName

'复制数据
    Range("a162:ai183").Copy ThisWorkbook.Worksheets(1).Range("b2")
    str_OpenRawData.Close False
    'Name str_OpenRawData_FullName As str_ThisFileParentPath & "02_Finished\" & str_OpenRawData_Name

'Copy Chart 复制图表为图片
    Dim str_ChartFullName As String


    str_ChartFullName = ThisWorkbook.Path & "\" & str_ChartName & ".jpg"
    ActiveSheet.ChartObjects(1).Chart.Export filename:=str_ChartFullName, filtername:="jpg"
    str_ChartFullNameb = ThisWorkbook.Path & "\" & str_ChartName & "_b" & ".jpg"
    ActiveSheet.ChartObjects(2).Chart.Export filename:=str_ChartFullNameb, filtername:="jpg"
    With frm_Chart
        .Img_Chart.Picture = LoadPicture(str_ChartFullName)
        .Img_Chartb.Picture = LoadPicture(str_ChartFullNameb)
        .lbl_title.Caption = Left(str_OpenRawData_Name, Len(str_OpenRawData_Name) - 4) & " 请判定归哪一类 "
        .lbl_ThisFileParentPath.Caption = str_ThisFileParentPath
        .lbl_OpenRawData_FullName.Caption = str_OpenRawData_FullName
        .lbl_OpenRawData_Name.Caption = str_OpenRawData_Name
        .lbl_ChartFullName.Caption = str_OpenRawData_Name
        .lbl_ChartName.Caption = str_OpenRawData_Name


    End With
    frm_Chart.Show

    str_ThisFileParentPath = ""
    str_OpenRawData_FullName = ""
    str_OpenRawData_Name = ""
    str_ChartName = ""
    ThisWorkbook.Worksheets("Run").Activate

End Sub

fengye5200

那位大神帮忙处理下啊