macro for saving multiple instances of an xls in multiple formats.

Hi,

I am having a finger of fudge with a macro at present. the problem is thus, i want an xls to auto save in the .xls format and in the mhtml format. The xls seems to be saving well at the allotted times, but the mhtml appears to be corrupt. If i manually save the mhtml, it opens in IE fine.

Here is the current code i am using:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If anyone has any ideas as to what the problem is it would be might handy. Also the mhtml format is not binding but i would like something to be opened in a browser along with the .xls

Many thanks for you help and advice in advance
Idris