Microsoft Office Forums - View Single Post - Use VBA to open the dialog box to All Files instead of All Word Documents

Thread: Use VBA to open the dialog box to All Files instead of All Word Documents

View Single Post

Old

05-13-2014, 01:32 AM

macropod

macropod is offline

macropod uses Windows 7 32bit

Windows 7 32bit macropod uses Office 2010 32bit

macropod uses Office 2010 32bit

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

Default

Try:

Code:

Sub Demo()
With Dialogs(wdDialogInsertFile)
  SendKeys "%n{TAB}t", True
  SendKeys "{TAB}{TAB}{TAB}{TAB}{ENTER}W:\Daily to Fortis\Today\{ENTER}", True
  .Show
End With
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply With Quote