Help required in sending file as an attachment.

[A9kurs]

Hi Guys,


I found this on excel forum.
I am trying to modify the code. This code is working but its not sending the temp file as attachment. Please Help I just want to modify this code so that i can send the temp file in attachment.

Thanks in advance

Please Login or Register  to view this content.

[davesexcel]

The code attaches the workbook for me, even though it has no data in it.

You have a few lines that are deleting the rows.

Please Login or Register  to view this content.

[Greg M]

Hi there,

I'm probably missing something, but when I run your code it generates an email with a .htm attachement - admittedly the attachment contains only a header because all of the entries in your workbook are more than 120 days old.

Do you want to attach a copy of your temporary workbook as an Excel file (.xlsx, .xlsb)?

Regards,

Greg M

[A9kurs]

Hi Greg

I just want to attach a copy of temporary workbook as an excel file .xlsb

Hi there,

I'm probably missing something, but when I run your code it generates an email with a .htm attachement - admittedly the attachment contains only a header because all of the entries in your workbook are more than 120 days old.

Do you want to attach a copy of your temporary workbook as an Excel file (.xlsx, .xlsb)?

Regards,

Greg M

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[Greg M]

Hi again,

Many thanks for the Reputation increase - much appreciated!

Glad I was able to help.

Best regards,

Greg M