So I've been asked to change the name of the attachments that are regularly being sent out. Currently they are being emailed out with the directory of where they are (i.e._folder_anotherfolder_thenthisfolder_andinhere_attachment_thisexcelreport)
when I need it to be called 'This Excel Report' I'm not too sure how to go about this, I'm fairly new to vb!

I have mail.AddAttachment("C:/folder1/folder2/folder3/ExcelDownloads/Attachment_excelreport1.xls") can I just input some code that says- Dim attachment As Net.Mail.Attachment = New Net.Mail.Attachment("Excel Report") or will this not work?

I have also been told I can use ExportDataTableToExcel(ms, org.Name.Replace(" ", "_") & "_excelreport1.xls") to do it but I'm unsure how to do that.

Any ideas at all?