Khalid_exel
New Member
- Joined
- Jul 17, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
I use this code:
to save file to pdf in the same folder
my question
I want to save the PDF file with a name similar to a cell in the sheet
can any one help me to do that ?
thanks
VBA Code:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Left(ActiveWorkbook.FullName, InStrRev(ActiveWorkbook.FullName, ".")) & "pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=True, OpenAfterPublish:=False
my question
I want to save the PDF file with a name similar to a cell in the sheet
can any one help me to do that ?
thanks