issue with excel after saveas overwrite data

Question

So I have written the below code that open my excel file and save it as text file

Dim xl As New Excel.Application
Dim xlBook As Excel.Workbook = xl.Workbooks.Open("C:\ExcelData.xlsx")
Dim xlSheet As Excel.Worksheet = xlBook.Sheets("Sheet1")

xlSheet.SaveAs("C:\Data.txt", Excel.XlFileFormat.xlTextWindows)

xlBook.Close

The problem is after it save the file i9t prompt me do you want to save changes and when I click Yes it overwrite the file with the latest opned sheet from the excel.

How can I stop it from overwriting and stop it from prompt me for changes?

-1 this shows no research effort. This has been asked (and answered) many times already — Matt Wilko, Feb 13 '14 at 09:21

score 2 · Accepted Answer · answered Feb 13 '14 at 09:13

2

If you add the following line at the start of your macro:

Application.DisplayAlerts = False

Then no dialog boxes will appear during its running. This will include the popup that shows when closing xlBook.

answered Feb 13 '14 at 09:13

Phylogenesis

7,775
19
27

This is a vb.net application windows application not a macro. – MohammadMMohammad Feb 13 '14 at 09:15
When I added it it gave me the below error: Error 13 'DisplayAlerts' is not a member of 'System.Windows.Forms.Application'. – MohammadMMohammad Feb 13 '14 at 09:15
That should probably be `xl.DisplayAlerts = False` then. – Phylogenesis Feb 13 '14 at 09:17
If you like my question upvote it – MohammadMMohammad Feb 13 '14 at 09:19
You don't like my question? – MohammadMMohammad Feb 13 '14 at 10:11
@MohammadMMohammad - Please stop asking for up-votes on all your questions. – Matt Wilko Feb 18 '14 at 09:14
Why? what's in it with you? – MohammadMMohammad Feb 19 '14 at 06:46
There is no rule prevent me asking for up-votes. – MohammadMMohammad Feb 19 '14 at 06:48

issue with excel after saveas overwrite data

1 Answers1