Results 1 to 6 of 6
  1. #1
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Normal.dot already open (Word 2000 SR-1)

    Is there a way to tell if a user already has normal.dot open when Word is open?

    The normal.dot is on a network drive, so if a user attempts to open Word when it's open on another machine, an error is generated when I attempt to save the Normal.dot on the second machine. I'm not fond of error trapping for this sort of thing- I'd prefer a more elegant solution, and a softer landing for the user.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Normal.dot already open (Word 2000 SR-1)

    The file format is messy, but the user name (names?) appears in ~$normal.dot. Does this help?

    Sub ShowUser()
    'use your own paths here...
    MsgBox TemplateUser("d:msofficetemplates~$normal.dot")
    MsgBox TemplateUser("d:msofficetemplates~$madeupname.dot" )
    End Sub

    Function TemplateUser(strTemplate As String) As String
    Dim intFile As Integer, intStop As Integer, strUser As String
    intFile = FreeFile
    On Error GoTo notOpen
    Open strTemplate For Input As #intFile
    Line Input #intFile, strUser
    intStop = InStr(2, strUser, Chr(15))
    If intStop > 2 Then
    TemplateUser = Mid(strUser, 2, intStop - 2)
    Else
    TemplateUser = "Unknown"
    End If
    Close #intFile
    Exit Function
    notOpen:
    TemplateUser = "NotInUse"
    End Function

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Normal.dot already open (Word 2000 SR-1)

    That's good. I hadn't thought of looking for, let alone looking in, ~$normal.dot.

    I will though add a dir command before the "open"- so that I can check to see if it exists before I open it. That way I can avoid relying on error processing.

    Thanks for the code.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    BAM
    Guest

    Re: Normal.dot already open (Word 2000 SR-1)

    Hi Geoff,

    I'm sure you are already aware of the pitfalls in sharing Normal.dot but here they are again anyway.
    (Taken from my library of "canned" responses <img src=/S/grin.gif border=0 alt=grin width=15 height=15>)

    The main reasons for this are:
    1) It decreases your chances of spreading viruses (Not everyone should share the same Kleenex!)

    2) If Word can't find the network for any number of reasons, then it will create a new Normal.dot on the local drive. When there is more than one Normal.dot then this begins to cause additional problems, errors, etc.

    3) Any changes one user makes affects all users. This is why you are getting "Save Normal.dot?" Someone has made a change. This type of situation can lead to various error messages and can lead to the corruption of Normal.dot. (And in your case, necessitating a macro that checks to see if the Owner file for Normal.dot exists (~$Normal.dot). Big problem I see there is what if Word crashes and the Owner file is not deleted correctly?)

    4) Microsoft does not recommend you do this either. Additional information can be found in this article from the MS KB:
    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q167/2/84.ASP>http://support.microsoft.com/support/kb/ar...s/Q167/2/84.ASP</A>

    If the reason Normal.dot is setup as shared is because of global AutoText entries, macros, styles, etc. then these should be placed in a separate template and folder on the server and point each users Startup location to that folder. Upon starting the template will be loaded as a global add-in and all items will be available to the user and a little more protected than they would be if stored on a shared Normal.dot.
    ~~~~~~~~~~~~~~~
    Cheers! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Normal.dot already open (Word 2000 SR-1)

    BAM,

    I didn't make myself quite clear enough.

    Normal.dot is in the network- but what I had not specified was, that it's on a path only available to that user.

    The idea is that if the user moves from one PC to another, the same settings will be retained.

    But some users log onto Word on one machine, leave Word on, and then log onto another machine. That's when I run into problems with saving Normal.dot.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  6. #6
    BAM
    Guest

    Re: Normal.dot already open (Word 2000 SR-1)

    Hi Geoff,

    Ah! That makes perfect sense now. I'm glad you clarified.

    As I was adding my reply I thought to myself, certainly Geoff knows that sharing Normal.dot can cause all sorts of problems! LOL
    ~~~~~~~~~~~~~~~~
    Cheers! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •