gagandeepcheema
New Member
- Joined
- May 13, 2019
- Messages
- 1
I am trying to export my excel sheet in pdf file but I am getting this Run Time Error 5 - Invalid Procedure Call or Argument
Can someone help me to get rid of this error and save the desired sheet to pdf file
Sub MakePdf()
Sheet1.Range("A1:C1").ExportAsFixedFormat xlTypePDF, Filename:="D:\Invoice\Export.pdf", OpenAfterPublish:=True
End Sub
Can someone help me to get rid of this error and save the desired sheet to pdf file
Sub MakePdf()
Sheet1.Range("A1:C1").ExportAsFixedFormat xlTypePDF, Filename:="D:\Invoice\Export.pdf", OpenAfterPublish:=True
End Sub