注册 登录
编程论坛 VB6论坛

VB6 提取excel 中的图片无法显示

zhgfeng20 发布于 2020-08-23 19:19, 1278 次点击
用以下命令从Excel 中提取的图片,不能显示,每次不显示的图片编号还不一样。求高手指教。谢谢。

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Set xlApp = CreateObject("Excel.Application")
        xlApp.Visible = True
        Dim a(1 To 6) As String
        Dim b(1 To 20) As String
        Dim n As Integer
        a(1) = "1-1"
        a(2) = "1-2"
        a(3) = "2-1"
        a(4) = "2-2"
        a(5) = "3-1"
        a(6) = "3-2"
        b(1) = "0001"
        b(2) = "0002"
        b(3) = "0003"
        b(4) = "0004"
        b(5) = "0005"
        b(6) = "0006"
        b(7) = "0007"
        b(8) = "0008"
        b(9) = "0009"
        b(10) = "0010"
        b(11) = "0011"
        b(12) = "0012"
        n = 1
        For j = 1 To 12
               For i = 1 To 6
                    Set xlBook = xlApp.Workbooks.Open("C:\Users\HG\Desktop\Temp1\" & b(i) & "\" & a(i))
                    Set xlSheet = xlBook.Worksheets(1)
                    xlSheet.Activate
                    Clipboard.Clear  
                    xlSheet.Shapes(1).Copy
                     Image1.Picture = Clipboard.GetData   
                     SavePicture Image1, "C:\Users\HG\Desktop\Temp2\" & n & ".jpg"
                     n = n + 1
                     xlBook.Close
                     xlApp.Quit
                     Set xlSheet = Nothing
                     Set xlBook = Nothing
                     set xlApp=nothing
                     
             Next i
       Next j
      
    xlApp.Quit
    Set xlSheet = Nothing
    Set xlBook = Nothing
    set xlApp=nothing
   
End Sub
0 回复
1