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:
Public DTime As Date
DTime = Time
Application.OnTime DTime + TimeValue("00:00:30"), "SaveMe_MistakesandAll"
ActiveWorkbook.SaveAs Filename:="C:Documents and SettingsnavMy Documentsautosavinghess_egypt_line_log2.htm"
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