Corrupted File help please

Hello

I am using Macro to send many emails with Excel sheets, Version 1997-2003 but some receipients are unable to open it a security message comes and then, when clokcing ok it comes in a strange format

any idea what could be the cause ?

Thanks

Originally Posted by :) Sixthsense :)

Please let us know the Security Message Text

"he file format and extension don't match, the file could corrupted or unsafe, unless you trust the source, don`t open it do you want to open it anyway ? "

Thanks

Originally Posted by :) Sixthsense :)

What extension it shows?

"Xls" meant to be 1997-2003 Excel format

Originally Posted by HaHoBe

Hi, bimo,

check the setting for the standard new workbook on your system (should be one of the 2007 on formats) and make sure to add the fileformat to your macro like

Please Login or Register  to view this content.

where 56 stands for

Ciao,
Holger

Hi HahoBe,

this what I use

Please Login or Register  to view this content.

I ll try your formulae and report back, Thanks

there still an issue, the recepient, can not open it, sometimes it just says Corrupted. the solution at the moment I have to re save individul Excel File and Re Send them, doesn t matter what version, and it works then