Saving Excel Files to Correct Format with Macro

[Smurlos]

I have a macro which copies a sheet to a new workbook and then saves the workbook and attaches it to an e-mail.

When I open the attachment in the e-mail, it shows the following error:

"the file that you are trying to open is in a different format than specified by the
file extension. Verify that the file is not corrupted and is from a trusted source before
opening the file. Do you want to open the file now?"

When I click "yes" to open the file, the file is fine. However, when the email is sent to customers, the error scares them a bit and a lot of them do not wish to open the file.

My code is as follows:

Please Login or Register  to view this content.

Thanks in advance

[Huron]

I'm not sure what version of Excel you're using - is it 2007? If so, the file extension should be .xlsx or .xlsm. If you rename a .xlsx file with a .xls extension you will get the error message shown when you try to open it.

To save the file as Excel 2003 add FileFormat :=xlExcel8 to the Save As line

Please Login or Register  to view this content.

[Smurlos]

I'm not sure what version of Excel you're using - is it 2007? If so, the file extension should be .xlsx or .xlsm. If you rename a .xlsx file with a .xls extension you will get the error message shown when you try to open it.

To save the file as Excel 2003 add FileFormat :=xlExcel8 to the Save As line

Please Login or Register  to view this content.

Thanks for your help