Macro prompts to save the changes.....can i default it to yes

[jeep2001]

I have an Excel macro that I run from Access.
It deletes a column in a spreadsheet...Before the delete takes place, there is a prompt "Do you want to save the changes..." . Is there a way in EXCEL to make this go away...

 

[longhair]

jeep2001,
from excel help:
DisplayAlerts Property Example

This example closes the workbook Book1.xls and doesn’t prompt the user to save changes. Any changes to Book1.xls aren’t saved.

Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True

regards,
longhair

 

[jeep2001]

Can I force the changes to yes without user input in the macro?

 

[longhair]

jeep2001,
if i understand you correctly, now - you want to save the changes and not show alerts. correct?
then use the above code to disable the alerts and code the save.
search the help file for 'save' - i believe it is application.save or application.saveas.
regards,
longhair

 

[jeep2001]

thank you

 

[AnotherHiggins]

jeep2001,

For future reference: Macro/VBA questions should be asked in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.