从Excel中导出图片

最新推荐文章于 2025-04-18 16:27:17 发布

转载最新推荐文章于 2025-04-18 16:27:17 发布 · 576 阅读

文章标签：

#EXCEL #VBA

VBA 同时被 2 个专栏收录

6 篇文章

订阅专栏

Excel

6 篇文章

订阅专栏

本文介绍了一种使用VBA宏将Excel工作表中的图片导出为硬盘上的JPG文件的方法。首先需要选择要导出的图片，然后通过创建临时图表并调整其尺寸来匹配所选图片的大小。接下来复制选定的图片并将其粘贴到该图表中，最后导出图表为指定的JPG文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

原文链接：http://www.vbforums.com/showthread.php?538529-Export-an-Image-from-Excel-Sheet-to-Hard-Drive

Option Explicit 
'You need to select a picture before running this code
'else it will give you error'
Sub PictureExport()
    Dim TempChart As String, Picture2Export As String
    Dim PicWidth As Long, PicHeight As Long
      
    Picture2Export = Selection.Name
      
    'Store the picture's height and width  in a variable
    With Selection
        PicHeight = .ShapeRange.Height
        PicWidth = .ShapeRange.Width
    End With
      
    'Add a temporary chart in sheet1
    Charts.Add
    ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
    Selection.Border.LineStyle = 0
    TempChart = Selection.Name & " " & Split(ActiveChart.Name, " ")(2)
      
    With ActiveSheet
        'Change the dimensions of the chart to suit your need
        With .Shapes(TempChart)
            .Width = PicWidth
            .Height = PicHeight
        End With
            
        'Copy the picture
        .Shapes(Picture2Export).Copy
            
        'Paste the picture in the chart
        With ActiveChart
            .ChartArea.Select
            .Paste
        End With
            
        'Finally export the chart
        .ChartObjects(1).Chart.Export Filename:="Sample.jpg", FilterName:="jpg"
        'Destroy the chart. You may want to delete it...
        .Shapes(TempChart).Cut
      End With
End Sub