I apologize, I understand your frustration and appreciate you hanging in there with me. Here is my code, copied and pasted from my word vbe:
module
Option Explicit
Dim oAppClass As New ThisApplication
Public Sub AutoExec()
Set oAppClass.oApp = Word.Application
End Sub
Thanks and sorry...
Ugh! I didn't type it here. Sorry, I do have that. I can't copy paste my code. Typing this from my home pc and code is on my work pc.
In Module
option Explixit
Dim oAppClass As New ThisApplication
Public Sub AutoExec()
Set oAppClass.oApp = Word.Application
End Sub...
Sorry I guess I should have been more specific...nothing happens, no errors, no nothing when I click on Save. It should activate the BeforeSave event...well, at least that is what I want it to do.
As far as the code, it i a mistype. I was missing an End Sub.
In Module
option Explixit
Dim...
HI, PLEASE PLEASE anyone, I really need help with this!
I created some code using this example:
http://word.mvps.org/faqs/macrosvba/AppClassEvents.htm
Instead of using the Quit event they use, I am using the DocumentBeforeSave Event.
However it is not working. Just in case it will help...
Hi, Thanks for your help. I did not create that portion of the code. The business did. I'm just helping to make it into an addin, bbut thank you for the code, I might suggest I change it for them so it won't be so cumbersome to change when they need to.
Back to my issue.
In repsonse to your...
Here is my code:
Option Explicit
Public DocEmpty As Boolean
Public ChangesFound As Boolean
Private Sub appWord_DocumentBeforeSave _
(ByVal Doc As Document, _
SaveAsUI As Boolean, _
Cancel As Boolean)
Call EditingMacroComments
End Sub
Private Sub...
Hi, Sorry for the confusion...maybe I provided too much info
Basically I have some vba code that on save or save as is suppose to check the document verbiage and search for particular words and make comments. The user needs to have this happen automatically, we do not want them to click on a...
Hi, I've created a Word addin that checks the word document for some verbiage. This needs to be activated when the user attempts to save the document (Save or Save As). This is created in the Normal.dot. The vba code works fine when used as a template (not in Normal.dot) but it deos not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.