Return FolderPath to add attachment to email

[rtcwlomax]

Hi All,

I have code which creates a folder and saves a sheet within the folder as PDF. This works fine but when I try to generate an email with PDF attachment I cant seem to get the folder path to return in my code.

Any help appreciated.

Please Login or Register  to view this content.

[JosephP]

I guess your A3 in reality does not include the ".pdf" extension which gets added when the export to pdf is done. hence your Dir fails and Create_PDF never gets a value. either specify the .pdf in the cell or add it in the code.

[rtcwlomax]

I guess your A3 in reality does not include the ".pdf" extension which gets added when the export to pdf is done. hence your Dir fails and Create_PDF never gets a value. either specify the .pdf in the cell or add it in the code.

Doh!

Thanks JP