Re: Keeps asking to save/change normal.dot after I've thrown data from VB6 to MS Word

Discussion in 'Word VBA Beginners' started by Mojo, Apr 26, 2011.

  1. Mojo

    Mojo Guest

    Hi All

    I just can't pin this one down.

    I have a vb6 app that connects and throws data at a MS Word doc template
    that I've pre-created. The doc population works fine (ie a copy of the
    template is used and values put into it) and at the end of the process the
    doc is displayed to the user, but when the user tries to close the doc or
    quit the Word app then **some** users seem to get into a little loop of
    asking if they want to update the normal.dot file. They click cancel to the
    Save As window, try to close and asked about it again.

    This doesn't seem to be version specific, because I've seen the same
    app/word template setup on numerous WinXP/Vista/7 machines using Office
    2000/2003/2007/2010 and it works fine, but I've got a large preportion of
    users who get this annoying loop everytime they call it.

    Now from my point of view the only thing I can think it is is that I use a
    WordBasic line to manipulate the filename that is displayed when you go to
    File/Save As.

    This obviously manipulates the properties window and might twiddle the
    normal.dot props as well, but why??

    I've got access to 3 machines and none of them have generated this kind of
    problem.

    Is there any sure fire way of stopping this normal.dot cafuffle or should I
    drop the WordBasic line to give the PC a chance?

    Thanks
     
    Mojo, Apr 26, 2011
    #1
    1. Advertisements

  2. Mojo

    That Guy Guest

    Re: Keeps asking to save/change normal.dot after I've thrown datafrom VB6 to MS Word

    I have no explanation as to why this happens. I can only say that I
    have dealt with it ever since I started using VB to enter data into
    word documents.

    WordApp.NormalTemplate.Saved = True

    add this line where ' WordApp ' is your word application object.

    I know this works just fine for me and has for a while.
     
    That Guy, Apr 27, 2011
    #2
    1. Advertisements

  3. Mojo

    Mojo Guest

    Hi That Guy

    Many, many thanks for this.

    "That Guy" <> wrote in message
    news:...
    I have no explanation as to why this happens. I can only say that I
    have dealt with it ever since I started using VB to enter data into
    word documents.

    WordApp.NormalTemplate.Saved = True

    add this line where ' WordApp ' is your word application object.

    I know this works just fine for me and has for a while.
     
    Mojo, Apr 27, 2011
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.