Attach current excel file to email sent using CDO

[andrewb90]

Hello all,

My question has multiple parts to it. Basically, I already have my CDO code and functions that can send emails and attach a pdf of different sheets. What I am looking for is:
a) a way to locate the file location that the current workbook is in.
b) add that file location to my cdo code and attach and send it out.

I can provide further info as needed, I figured I'd start with this, and go from there.

Any help in the right direction would be greatly appreciated.

 

[FormR]

Hi,

"ActiveWorkbook.FullName" returns the path and file name of the active workbook.
"ActiveWorkbook.Path" returns just the path.