My users are opening Excel sheets through IE.

I'm trying to run this macro...

Sub Macro1()
ThisWorkbook.SaveCopyAs "c:\temp.xls"
End Sub

But it will give me a
run-time error 1004.
Method 'SaveCopyAs' of object '_Workbook' failed.

If I go to debug mode and play again.. it will go through. Thanks fo
any tips

--
Message posted from http://www.ExcelForum.com