View Single Post
 
Old 05-12-2014, 09:19 AM
spencerw.smith spencerw.smith is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2014
Posts: 3
spencerw.smith is on a distinguished road
Default 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
Reply With Quote