Hopefully I am posting this is the correct discussion, but I am creating a database to link to the production files that we use at work. These files are both Excel and Word. I have a BeforeSave macro that runs as an Add-in on both of the Excel and Word files that I am linking to. The problem is that the when I hyperlink to the Word documents from Access, the BeforeSave event in the Word add-in does not function. When I open the document directly, the BeforeSave event works fine. The Excel files work fine from the Access hyperlinks, it's just the Word documents that I am having an issue with. I don't have any Access Code at this point as I just started working on this database, but I don't have any experience working with VBA in Access anyway. I mainly work with Excel and Word VBA.
If it helps, I have put the Word add-in code below.
Module (mdlEventConnect):
Code:
Option Explicit
Public EventHandler As New clsEventHandler
Public Sub Register_Event_Handler()
Set EventHandler.App = Word.Application
End Sub
Public Sub AutoExec()
Register_Event_Handler
End Sub
Class Module (clsEventHandler):
Code:
Option Explicit
Public WithEvents App As Word.Application
Private Sub App_DocumentBeforeSave(ByVal Doc As Document, SaveAsUI As Boolean, Cancel As Boolean)
'Insert long frustrating code here
End Sub
Again, I don't have any experience with Access VBA, so I am at a lose right now with what I need to do. Any help would be appreciated! Thank you - David