Hi Roy,

Thanks for trying to help me out. Unfortunetly, the code you provided me
just created a seperate message box, and didn't default the original to yes.


--
Regards,

timmulla


"Roy Wagner" wrote:

Try this...

x = MsgBox("Default to yes", vbYesNoCancel + vbDefaultButton1, "Default")

Roy
--
(delete .nospam)




"timmulla" wrote:

Thanks for your help JE McGimpsey!

It solved my first problem successfully. Do you, or anyone else know how to
help me with the second problem? I need to default the following message box
to yes:

A file named "'Consolidated Programs import MONTHLY GL UPLOAD.txt already
exists, do you want to replace it?

I'm going to be replacing the file under the same name each time I use the
macro.

Thanks again for your help!
--
Regards,

timmulla


"JE McGimpsey" wrote:

Wrap your Save/SaveAs method with

Application.DisplayAlerts = False
'Save
Application.DisplayAlerts = True



In article ,
"timmulla" wrote:

I was wondering if anyone could help me with a macro I'm creating?

I'm trying to disable a message box "Do you want to save changes to
'Consolidated Programs import MONTHLY GL UPLOAD.txt" which pops up when my
macro is running. I want this to automatically default to yes each time the
macro is run. I also want the message box that says "'Consolidated Programs
import MONTHLY GL UPLOAD.txt already exists, do you want to replace it? To
default to yes as well.

Basically, I'm running a open workbook macro in one file to convert the
"Consolidated Programs import MONTHLY GL UPLOAD.xls" to a text file. The
message boxes are stopping the rest of my code from executing.

Any help would be appreciated.

Thanks,

Tim