
10-11-2003, 12:38 PM
|
|
Freshman
|
|
Join Date: Oct 2003
Location: Canada
Posts: 28
|
|
Clearing FileName in Save As...
|
Good day to all those in coding land!
Curious about something.
Is there a way to clear the FileName from a "Save As.." Common Dialog Popup.
Here is the full situation.
I open a file using the following:
Code:
With CommonDialog1
.CancelError = True
.Filter = "Excel Files (*.xls)|*.xls"
.FilterIndex = 1
.DialogTitle = "Select the file..."
.ShowOpen
End With
Then shortly after the file is opened, i have to save ANOTHER file using the same Commong Dialog Box.
Code:
With frmSort.CommonDialog1
.CancelError = True
.Filter = "Excel Files (*.xls)|.xls"
.DialogTitle = "Save " + strFileNumber + " File As..."
.ShowSave
.FileName = ""
End With
For 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.
Htanx for the help in advance,
Ulysses
|
|