K
Kenny G
Hello,
I have code goes to the W drive and have filtered the different .DOC
documents.
Private Sub cmdOIDD_Click()
Dim dlgOpen As FileDialog
Set dlgOpen = Application.FileDialog(msoFileDialogFilePicker)
With dlgOpen
.InitialFileName = "W:\Monthly\????????.CENSUS-UH-NS-SUMMARY-IP.DOC"
.Show
.AllowMultiSelect = False
End With
End Sub
This allows me to select among the monthly .doc documents I want to use.
The situation is:
I want to select one by highlighting it.
The selected document is to be saved it to my C drive with the same filename
except the extension is to be .txt.
I appreciate your help.
I have code goes to the W drive and have filtered the different .DOC
documents.
Private Sub cmdOIDD_Click()
Dim dlgOpen As FileDialog
Set dlgOpen = Application.FileDialog(msoFileDialogFilePicker)
With dlgOpen
.InitialFileName = "W:\Monthly\????????.CENSUS-UH-NS-SUMMARY-IP.DOC"
.Show
.AllowMultiSelect = False
End With
End Sub
This allows me to select among the monthly .doc documents I want to use.
The situation is:
I want to select one by highlighting it.
The selected document is to be saved it to my C drive with the same filename
except the extension is to be .txt.
I appreciate your help.