How to turn Excel Delete Warning off

[Bob]

In the following code, when the DELETE line is executed I get a dialog asking if I want to delete or to cancel. How do I turn it off? Also when the first CLOSE line is executed, the application so to sleep.

Dim strTabName = Path.GetFileNam eWithoutExtensi on(strSourceWor kBookName)
Dim wbSOURCE As Excel.Workbook
Dim wbTARGET As Excel.Workbook

With appExcel
wbSOURCE = .Workbooks.Open (strSourceWorkB ookName)
wbTARGET = .Workbooks.Open (strTargetWorkB ookName)
wbTARGET.Sheets (strTabName).se lect()
wbTARGET.Active Sheet.delete()
wbTARGET.Close( True)
wbSOURCE.Close( )
.Quit()
End With

[Cor Ligthert]

Bob,

This is using Office programming in a Net wrapper. It is interopp. For this
kind of questions you get probably a better or more answers in a real office
developer newsgroup..

microsoft.publi c.office.develo per*

There are a lot.

I hope this helps?

Cor

[Herfried K. Wagner [MVP]]

* =?Utf-8?B?Qm9i?= <Bo*@discussion s.microsoft.com > scripsit:

In the following code, when the DELETE line is executed I get a dialog
asking if I want to delete or to cancel. How do I turn it off? Also
when the first CLOSE line is executed, the application so to sleep.
Dim strTabName = Path.GetFileNam eWithoutExtensi on(strSourceWor kBookName)
Dim wbSOURCE As Excel.Workbook
Dim wbTARGET As Excel.Workbook

With appExcel
wbSOURCE = .Workbooks.Open (strSourceWorkB ookName)
wbTARGET = .Workbooks.Open (strTargetWorkB ookName)
wbTARGET.Sheets (strTabName).se lect()
wbTARGET.Active Sheet.delete()
wbTARGET.Close( True)
wbSOURCE.Close( )
.Quit()
End With

\\\
With Application
.DisplayAlerts = False
ThisWorkbook.Sa veAs("D:\file.x ls")
.DisplayAlerts = True
End With
///

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>