Use VBA to open the dialog box to All Files instead of All Word Documents
I have code that is automatically importing a csv file into microsoft word and saving it as a pdf file. You press the button and the macro automatically opens the dialog box where the user selects the csv file to import but every time the dialog box opens the default opens with "All Word Documents" selected (only viewing word docs) but I want the default to be "All Files" so that you can actually see the CSV files and not have to manually change it every time.
How can I change the dialog box so that it automatically opens with all "All Files" selected instead of "All Word Documents"?
Here is the part of the code that prompts the dialog box:
Options.DefaultFilePath(wdDocumentsPath) = "W:\Daily to Fortis\Today"
With Dialogs(wdDialogInsertFile)
.Name = "*.txt"
.Show
End With
Thanks
|