Save without confirm boxes appearing

Dan Aragon

MrExcel MVP
Joined
Feb 10, 2002
Messages
92
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
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
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>

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

Dan Aragon

MrExcel MVP
Joined
Feb 10, 2002
Messages
92
Funny, I didn't post this question. Someone else somehow posted this question with my name attached.

Maybe not so funny afterall...
 

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
Tell the admins about the glitch; your name can be removed, and perhaps someone will come forward and claim the post.
 

Kestrel

New Member
Joined
Oct 7, 2002
Messages
5
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.
 

Forum statistics

Threads
1,148,342
Messages
5,746,192
Members
423,997
Latest member
eakenila

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top