如何将我用VB.NE编辑的Excel文件保存到已存在的文件中？ Evertime有一个对话框：文件已经存在.你真的想覆盖吗？ YES | NO |中止
@H_403_1@如果没有此对话框,我该怎么覆盖？
你应该看看设置
DisplayAlerts=false@H_403_1@Application.DisplayAlerts Property
@H_403_1@Set this property to False if you@H_403_1@一旦完成,请记住将其重置为true. @H_403_1@我们目前这样做如下
don’t want to be disturbed by prompts
and alert messages while a program is
running; any time a message requires a
response,Microsoft Excel chooses the
default response.
object m_objOpt = Missing.Value; m_Workbook.Application.DisplayAlerts = false; m_Workbook.SaveAs( fileName,m_objOpt,XlSaveAsAccessMode.xlNoChange,XlSaveConflictResolution.xlLocalSessionChanges,m_objOpt);