Macro help anyone.....

[John O'Boyle]

I'm new to macros, and have created them, so far, only through the
"record macro" function. My problem macro performs a "save as" and then
(supposedly) closes the sheet. When running the macro I find I need to
manually intervene twice, once for the "file exists - overwrite?"
dialog, and again for the "save changes to?" dialog. Is there a way, in
the macro, for me to respond to these queries? I responded during the
"record" but it didn't seem to take.


Thanks.

JLOB

 

[Bob Phillips]

Try setting Application.DisplayAlerts = False before this code, it will then
just continue. Reset afterwards.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[John O'Boyle]

Do you have an example of how that statement is contructed and where
that statement should go? Do I just add it to my (edited) existing macro?


thanks.

J.

 

[Bob Phillips]

Sub yourMacro()

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="C:\myDir\myBook.xls"
' rest of code
Application.DisplayAlerts = True

End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[John O'Boyle]

Actually, thank you, I tried it (before I saw this note) with lines #1 &
#4. Everything seems to work as advertised. Do I really need line #2?

Thanks.
JLOB

 

[Bob Phillips]

I put that in as I assumed you had that in your code. line #3 does say ...
rest of code.

--

HTH

RP
(remove nothere from the email address if mailing direct)