cesymcox101
New Member
- Joined
- Jan 11, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I have inherited a macro-based file that has a radial button to convert the active sheet to a pdf. the issue is that it keeps debugging out on the saveaspdf macro. the code is listed below.
Worksheets(selectsheets()).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=ThisWorkbook.Path & "\" & Worksheets("Update Data").Range("D22") & ".pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
Welcome any solutions.
Worksheets(selectsheets()).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=ThisWorkbook.Path & "\" & Worksheets("Update Data").Range("D22") & ".pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
Welcome any solutions.