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:
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