Execute VBA on File Import

[npalmer610]

Hi, fellow forumers. I have several macros that I wish to execute across a file on import. I know you can execute VBA on close, save, even open, but I'm struggling to find the correct syntax to invoke macros after I've imported text into my blank file using the Import Text command, not copying and pasting. Of course, the code below is very rudimentary and it could well be that this is not a possibility in Word, but i'm hoping it is. The doc event listed below (Document_FileImport) is, of course, fictional. If anyone at least knows what the event name is, that would help immensely. Thanks for your help in advance.

Private Sub Document_FileImport()

  Call Macro1 
  Call Macro2
  Call Macro3 
  Call Macro4
  Call Macro5

End Sub

[macropod]

Presumably you want something like:

Sub InsertFile()
With Dialogs(wdDialogInsertObject)
  .Tab = 1
  .DisplayIcon = False
  .Link = False
  If .Show = True Then
    Call Macro1
    Call Macro2
    Call Macro3
    Call Macro4
    Call Macro5
  End If
End With
End Sub