Open dialog box in Word

[acjeff]

Hi,

I am writing some Ms Word macros. I need to export data to an Excel worksheet. I need a button to open a dialog box and let users to select the Excel file. How can I create a dialog box in Word macro?

Jeff

 

[CautionMP]

You can use a built-in dialog, here is a snipit that should get you moving in the right direction.

With Dialogs.Item(wdDialogFileOpen)
  .Name = "*.xls"
  If .Display = -1 Then
    MsgBox .Name, vbOKOnly, "User selected file:"
  Else
    MsgBox "The cancel button was pressed", vbOKOnly, "Operation canceled by user"
  End If
End With

Hope this helps,
CMP

(GMT-07:00) Mountain Time (US & Canada)