Re: on save macro launching

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Dariusz,

All I want is to launch a macro when user saves document. Macro should check
if a defined string is present in footer of document. If not - the macro
should open info form with possibility to enter missing string (string = id
+ date + sth... of document).
Please provide a sample of code or redirect me to appropriate page when I
could read how to realize it.

Before you can even start, you have to define how the macro should recognize
whether the string is there. From the looks of it, this is not a literal
string, but something that needs to be constructed. You have to define exactly
what the comparison needs to be...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

.

Relevant Pages

  • Compile-time text/string manipulation
    ... A "compile-time language" is one that processes ... Compile time languages for assemblers ... This group includes macro ... requires access to various string and text manipulation ...
    (alt.lang.asm)
  • Re: Need to get cell references from a formula
    ... I believe he is asking for the header text to be put in the formula in place of the cell reference, not the cell's value. ... Dim r As Range, v As String ... Select C2 on SheetX and run the above macro. ... > This newsgroup gets hundreds of messages posted to it daily. ...
    (microsoft.public.excel.programming)
  • RE: Search email for text string to use in filename - save email t
    ... The code for my macro is below. ... .MatchWholeWord = False ... Dim sNewFileName As String ... > 0 Then Exit Function ...
    (microsoft.public.outlook.program_vba)
  • Re: Document Property to display more than 1 line
    ... then use the following macro to identify the character ... Dim strNums As String ...
    (microsoft.public.word.newusers)
  • Re: Form refresh code
    ... Your version of the InserrtAddress macro also unlocked the field with the ... string variable name in the protect/unprotect commands. ... Public Sub InsertAddressFromOutlook() ... Dim strCode As String, strAddress As String ...
    (microsoft.public.word.docmanagement)