Thread: [Solved] Execute VBA on File Import
View Single Post
 
Old 04-12-2016, 03:12 PM
npalmer610 npalmer610 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2016
Posts: 5
npalmer610 is on a distinguished road
Default Execute VBA on File Import

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.

Code:
Private Sub Document_FileImport()

  Call Macro1 
  Call Macro2
  Call Macro3 
  Call Macro4
  Call Macro5

End Sub
Reply With Quote