The first time you save the workbook, it needs a path and filename. Use
SaveAs instead of Save, and provide a full name. This should avoid the Save
As dialog popping up.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"M. Hussaini" wrote in message
...
I have an Excel workbook that is created using VBA. I have set DisplayAlert
to False just before I save the Workbook. This does not seem to work as,
the
Save Dialog Box keeps coming up. I do not want this because I want to
automate the whole process. Any suggestions?