I am using a script task manager vba code, to remove a password from an excel file, but the problem is i get a message saying if want to replace the original file.
is there a way to disable the message when i run my stm.
Dim objExcel As Object
Dim objWorkbook As Object
objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
objExcel.DisplayAlerts = False
objWorkbook = objExcel.Workbooks.Open("C:\Development\Dashboard Feeds\???20120210.xls", , , , "test")
objWorkbook.Password = ""
objWorkbook.SaveAs("C:\Development\Dashboard Feeds\???20120210.xls")
objExcel.Quit()