Save without confirm boxes appearing

[Dan Aragon]

Afternoon.
I'm currently getting an error connecting to the database, so I don't know if I'll be able to access any responses, but here's my question.
I would like to save my active workbook as a csv file, and do so without having to answer the 'Are you sure' msg boxes each time. How to pre-confirm? I know I've seen an answer for this here before, but can't find it right now.

As always, your help and patience is appreciated.

Dagyr

 

[Richie(UK)]

Hi Dan,

Use Application.DisplayAlerts=False before the code to save.

Remember to switch back to true again afterwards - Excel may need to tell you something! :wink:

HTH

EDIT: Oops -typo!
_________________<font color="blue"> «««<font color="red">¤<font color="blue"><font size=+1>Richie</font><font color="red">¤<font color="blue"> »»»</font>

</gif>
This message was edited by Richie(UK) on 2002-10-07 16:40

 

[Dan Aragon]

Funny, I didn't post this question. Someone else somehow posted this question with my name attached.

Maybe not so funny afterall...

 

[stevebausch]

Tell the admins about the glitch; your name can be removed, and perhaps someone will come forward and claim the post.

 

[Kestrel]

Hey. I posted this with my username Dagyr. When I returned to the forum to cruise through topics, I couldn't access anything. I had to re-register under my other callsign. Sorry for the bother, but thanks for the help. The answer was simple and quickly answered, even if it was to the wrong person. Oh well.
K.