Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

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
0
OB1Canobie
Asked:
OB1Canobie
1 Solution
 
Shanan212Commented:
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now