asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Good Day,
Is it possible to create that PDF file with related worksheet name only?
Many Thanks
Is it possible to create that PDF file with related worksheet name only?
Many Thanks
VBA Code:
Sub Button1_Click()
On Error Resume Next
ChDir "\\172.16.23.181\xxxx\xxxxx"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"\\172.16.23.181\folder\xxxxx\xxxxx.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub