Im saving my file with the following statements:


With ActiveWorkbook.PublishObjects("Report-builder")
..HtmlType = xlHtmlStatic
..Filename = "C:\Report\Test.htm"
..Publish (False)
End With

But it overwrites a file with the same name. How do I
make it so that is checks if the user would like to overwite
or not?

Thanks




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