Hiding the Save As Window when using Excel

[hatman88]

Hello, I have a macro that writes to an Excel Spreadsheet and then saves it. However, when the spreadsheet is open a Save As window appears when it first wants to save. But after that, it doesn't appear again. Is there a way to make sure that the Save As window doesn't even appear the first time?

P.S. I already know about DisplayAlerts.

 

[WinblowsME]

http://www.tek-tips.com/viewthread.cfm?qid=1418613&page=1

 

[hatman88]

I already said that I know about DisplayAlerts. It's not problem...

 

[WinblowsME]

DisplayAlerts should take care of the problem you're describing. What is the problem? Post your code.

 

[lmbayley]

hatman88,

When you're telling the macro to save for the first time, are you specifying a filename? If you have a brand new spreadsheet and just hit the Save button, Excel will bring up the Save As box. Otherwise, how will it know where to save it?

If that isn't the problem, then, well, what WinblowsMe said... you'll have to post your code.

-LB