Return FolderPath to add attachment to email

**rtcwlomax** · 06-13-2012, 04:08 AM

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** · 06-13-2012, 04:50 AM

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** · 06-13-2012, 06:01 AM

Originally Posted by 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.

Doh!

Thanks JP