Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: saveas
How do I get rid of that window?
DB = ObjectOpen("Excel.Application") DB.DisplayAlerts =@FALSE ; this prevents the warning message from coming up oAPP = DB.Workbooks oAPP.Open("C:\WINDOWS\DESKTOP\test.XLS") oWKS = DB.Worksheets oWS = DB.Worksheets(1) oWS.Activate oWS.SaveAs(:: Filename="C:\WINDOWS\DESKTOP\test.XLS") ;note the oWS object here oAPP.close() ObjectClose(DB) exit
DB = ObjectOpen("Excel.Application") DB.DisplayAlerts =@FALSE ; this prevents the warning message from coming up oAPP = DB.Workbooks oAPP.Open("C:\WINDOWS\DESKTOP\test.XLS") oWKS = DB.Worksheets oWS = DB.Worksheets(1) oWS.Activate oWS.SaveAs(:: Filename="C:\WINDOWS\DESKTOP\test.XLS") ;note the oWS object here oAPP.close() ObjectClose(DB)
Article ID: W14696
Filename: Get SaveAs to Close without Alert Box.txt
File Created: 2001:02:09:16:12:46
Last Updated: 2001:02:09:16:12:46