Hi.

I use a macro to create a workbook. At the end of the macro I tel
excel to bring up the save as dialog using:

myname = Application.Dialogs(xlDialogSaveAs).Show
If myname = False Then MsgBox "You cancelled the Save operation."
vbInformation, "Cancelled"

the problem that I have is that it asks what version I want to use.
need to use excel vs 97. How can I get this dialog to stop asking m
for a version so that it just knows to save it in xl97 format

--
ianrippin

-----------------------------------------------------------------------
ianripping's Profile: http://www.excelforum.com/member.php...nfo&userid=320
View this thread: http://www.excelforum.com/showthread.php?threadid=27112