Good day to all those in coding land!
\r\n
\r\nCurious about something.
\r\n
\r\nIs there a way to clear the FileName from a "Save As.." Common Dialog Popup.
\r\n
\r\nHere is the full situation.
\r\n
\r\nI open a file using the following:
\r\n
\r\n
\r\n
Code:
\r\n
With CommonDialog1\r\n .CancelError = True\r\n .Filter = "Excel Files (*.xls)|*.xls"\r\n .FilterIndex = 1\r\n .DialogTitle = "Select the file..."\r\n .ShowOpen\r\nEnd With
\r\n
\r\nThen shortly after the file is opened, i have to save ANOTHER file using the same Commong Dialog Box.
\r\n
\r\n
\r\n
Code:
\r\n
With frmSort.CommonDialog1\r\n .CancelError = True\r\n .Filter = "Excel Files (*.xls)|.xls"\r\n .DialogTitle = "Save " + strFileNumber + " File As..."\r\n .ShowSave\r\n .FileName = ""\r\n End With
\r\n
\r\nFor some reason though. When i go to save the file it keeps the file name from the OPEN procedure. I want to have it BLANK where the user inputs the File Name in the Save As.. dialog.
\r\n
\r\nHtanx for the help in advance,
\r\n
\r\nUlysses
\r\n\r\n\r\n
Clearing FileName in Save As...
Threaded Mode
