Sub aaa()
Dim sht As Worksheet
For Each sht In Worksheets
Dim str As String
str = ActiveWorkbook.Path & "\pda°ü\" & sht.Name & ".pdf"
sht.ExportAsFixedFormat Type:=xlTypePDF, Filename:=str, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False
Next
End Sub
在excel 运行的
运行到这段时 sht.ExportAsFixedFormat Type:=xlTypePDF, Filename:=str, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False
提示 运行错误5 无效过程 或者参数。
但该段代码是用 录制宏 录出来的!! 就修改了 历遍 所有 sheet 而已 不知道怎么搞 求帮助!