hi all,
I created a macro to auto send emails as save each tab as an individual PDF.
It was working until now.
The issues seem to be the path to the sharepoint. Since Internet explorer is not mapping in the file explorer it looks like my DESTFOLDER is recognised anymore.
It shows me that the below has a bug.
'Create the PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=OpenPDFAfterCreating
I know that it looks like a different issue but if I use a previous sharepoint path it works.
Any idea what I need to fix?
I created a macro to auto send emails as save each tab as an individual PDF.
It was working until now.
The issues seem to be the path to the sharepoint. Since Internet explorer is not mapping in the file explorer it looks like my DESTFOLDER is recognised anymore.
It shows me that the below has a bug.
'Create the PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=OpenPDFAfterCreating
I know that it looks like a different issue but if I use a previous sharepoint path it works.
Any idea what I need to fix?
