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

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.
Similar Threads
  1. Ed
    Replies:
    13
    Views:
    189
  2. kurt

    macros and non normal.dot autotext entries

    kurt, Nov 14, 2004, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    183
    Jean-Guy Marcil
    Nov 15, 2004
  3. kurt
    Replies:
    1
    Views:
    144
    Jean-Guy Marcil
    Nov 15, 2004
  4. Srini
    Replies:
    2
    Views:
    178
    Srini
    Aug 30, 2005
  5. Wolf

    Saving KeyBinding in normal.dot

    Wolf, Dec 1, 2005, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    214
    Tony Jollans
    Dec 1, 2005
  6. Sunny

    Problems with AutoNew in Normal.dot

    Sunny, Jul 14, 2006, in forum: Word VBA Beginners
    Replies:
    6
    Views:
    190
    Jean-Guy Marcil
    Jul 20, 2006
  7. Laphan
    Replies:
    20
    Views:
    400
    Tony Jollans
    Jan 4, 2009
  8. Mojo

    Normal.dot keeps bugging me!!

    Mojo, Mar 28, 2010, in forum: Word VBA Beginners
    Replies:
    4
    Views:
    390
    Klaus Linke
    Mar 29, 2010
Loading...