Excel Dialogue Screen Not Suppressed

I am trying to open an excel spreadsheet and save it as a tab delimited text file. My issue is that all of a sudden excel pops up a dialogue box asking if I want to Save the original document. I cannot find any way to suppress this. See code below:
excel.txt
OB1CanobieAsked:
Who is Participating?
 
Shanan212Connect With a Mentor Commented:
application.DisplayAlerts = False

Open in new window


Put that before your 'save' code

and at the end of your code

Application.DisplayAlerts = true

Open in new window

0
 
OB1CanobieAuthor Commented:
Changed the code per suggestion. Still getting the popup. See attached.
Capture.JPG
0
 
leonstrykerCommented:
Shanan212, he is already using that. Look in the sample code he is giving.

At which point does it pop the dialog box? Then you are saving it or when you are closing it?

Leon
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
OB1CanobieAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for OB1Canobie's comment #a39625120

for the following reason:

Figured out the issue.
0
 
OB1CanobieAuthor Commented:
Question was answered on my own without answer from any expert.
0
 
CodeCruiserCommented:
Either post the solution and accept that or delete the question please.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.