表为“质量证明书” 按字段 牌号 尺寸 长度保存为文件名帮改下代码。如:20HRB40012米 。谢谢!
Dim Book As New XLS.Book(ProjectPath & "Attachments\质量证明书新版.xls")
Dim fl As String = ProjectPath & "Reports\质量证明书新版.xls"
Book.Build() '生成细节区
Book.Save(fl) '保存工作簿
Dim flt1,flt2 As String
flt1 = fl
flt2 = ProjectPath & "Reports\质量证明书新版.pdf"
If Not FileSys.FileExists(flt1) Then
Messagebox.Show("文件不存在或已经被删除!","提示")
Return
End If
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(flt1)
wb.ExportAsFixedFormat(MSExcel.XlFixedFormatType.xlTypePDF, flt2)
App.Quit
[此贴子已经被作者于2014-8-29 10:28:57编辑过]