批量导出VSD文件到JPG文件 宏

本文介绍了一段VBA宏代码,用于将Visio(.VSD)文件批量转换为JPG格式图片。宏通过设置导出分辨率、尺寸、颜色格式等参数,确保输出图片质量,并按页面名称保存,适用于批量处理复杂图表。

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

**

批量导出VSD文件到JPG文件 宏

**
Sub Macro1()

'Enable diagram services
Dim DiagramServices As Integer
DiagramServices = ActiveDocument.DiagramServicesEnabled
ActiveDocument.DiagramServicesEnabled = visServiceVersion140 + visServiceVersion150

For i = 1 To Application.ActiveDocument.Pages.Count
Application.ActiveWindow.Page = Application.ActiveDocument.Pages.Item(i)

Application.Settings.SetRasterExportResolution visRasterUseCustomResolution, 600#, 600#, visRasterPixelsPerInch
Application.Settings.SetRasterExportSize visRasterFitToSourceSize, 7.354167, 10.833333, visRasterInch
Application.Settings.RasterExportColorFormat = visRasterRGB
Application.Settings.RasterExportOperation = visRasterBaseline
Application.Settings.RasterExportRotation = visRasterNoRotation
Application.Settings.RasterExportFlip = visRasterNoFlip
Application.Settings.RasterExportBackgroundColor = 16777215
Application.Settings.RasterExportQuality = 75

Application.ActiveWindow.Page.Export ActiveDocument.Path + “\” + Application.ActiveWindow.Page.Name + “.jpg”
Next

'Restore diagram services
ActiveDocument.DiagramServicesEnabled = DiagramServices

End Sub

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值