Results 1 to 14 of 14

Thread: Still not resolved

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2003
    Posts
    509

    Still not resolved

    I have a word template that is opened up by multiple users. the problem is if one user has it open then it says it is locked

    Someone suggested using a word template as many users can open it but i realised not at the same time.

    What i would like to do is to create an instance of my template, copy that, open it up insert my info and then delete it.

    Someone said something about documents.add but i do not understand where to go with this.

    Can someone help????????

  2. #2
    Hyperactive Member mudfish's Avatar
    Join Date
    Feb 2004
    Location
    Chit Chat
    Posts
    353
    I told you to try it.
    Is it open the dot?
    Try this to see what I am talking about!
    Copy your dot to your desktop and double click it. It should open up a doc not the dot.
    It should all so open up more then one doc if you double click it again.
    Mudfish AKA Bowfin
    I can spell "If" all day right, just a coder!


    "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." -- Ernest Hemingway

    Member of the ECCC

  3. #3
    Addicted Member nickname's Avatar
    Join Date
    Sep 2004
    Location
    Europe - Belgium
    Posts
    170
    You know, in Win2003 server you can easely work with a lot of people on the same document, maybe consider using that..

    Then you you have no troubles programming..

    greetz

    nickname
    Software Engineer
    DBA
    Webdesigner
    --
    to code or to be coded, that's the question

  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2003
    Posts
    509
    yea, i know what you are saying. i tried it and yep there is no readonly message

    HOWEVER, when someone on the server is opening that .doc, then when another user on another machine wishes to enter info in there i get a read only message, cannot understand why.

    Try this out if your on a server. Put a word template on the server, then enter info in there. Leave it open, go to another pc, and try to enter the .doc and you will see what i mean

  5. #5

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2003
    Posts
    509
    lol windows 2003 is not really a good option. The company would have to buy licences, then would have to install it, and this would cause disruption in the short term.

    Cheers for the opinion though

  6. #6
    Hyperactive Member mudfish's Avatar
    Join Date
    Feb 2004
    Location
    Chit Chat
    Posts
    353
    It might be the server your running like nickname said!
    Well can download to the local machine?
    Mudfish AKA Bowfin
    I can spell "If" all day right, just a coder!


    "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." -- Ernest Hemingway

    Member of the ECCC

  7. #7

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2003
    Posts
    509
    is there a procedure in vb were i can download from server to machine and delete it after it has been used???????

    I do not particularly go round to everybody and change code just for them. It would be unpractical

  8. #8
    Hyperactive Member mudfish's Avatar
    Join Date
    Feb 2004
    Location
    Chit Chat
    Posts
    353
    We pre-set machines with the entire VB package so we just make exe and download them to the local machine off the server! There is way to do it, we have a menu control new version getting out to the local machine. Lot of code and we verify on file size and download date.
    Mudfish AKA Bowfin
    I can spell "If" all day right, just a coder!


    "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." -- Ernest Hemingway

    Member of the ECCC

  9. #9

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2003
    Posts
    509
    My company have never used vb. All there programs were developed in access and have become corrupt. Therefore the only machine that has vb installed is my own and thats it.

    Isn't there a simple copy command that says copy from say \\server1\invoice\invoice.doc to c:\ ?????????

  10. #10
    Hyperactive Member mudfish's Avatar
    Join Date
    Feb 2004
    Location
    Chit Chat
    Posts
    353
    You can use a batch job in dos to copy the dot to local machines.
    And vb could do it all so.
    Mudfish AKA Bowfin
    I can spell "If" all day right, just a coder!


    "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." -- Ernest Hemingway

    Member of the ECCC

  11. #11

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2003
    Posts
    509
    How do i make this work?

    It keeps saying object type not defined. am i missing a reference and if yes which one?

  12. #12
    Hyperactive Member mudfish's Avatar
    Join Date
    Feb 2004
    Location
    Chit Chat
    Posts
    353
    show me the code that it flags
    Mudfish AKA Bowfin
    I can spell "If" all day right, just a coder!


    "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." -- Ernest Hemingway

    Member of the ECCC

  13. #13

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2003
    Posts
    509
    sorry missed the code

    VB Code:
    1. Dim objfso As New FileSystemObject
    2. objfso.CopyFile "D:\Test.txt", "C:\"

  14. #14
    Hyperactive Member mudfish's Avatar
    Join Date
    Feb 2004
    Location
    Chit Chat
    Posts
    353
    here some code for copy

    Code:
    If Dir("C:\SCVRTemp\Authorize_Revised") <> "" Then Kill "C:\SCVRTemp\Authorize_Revised"  'If there remove
    
    Kill File_Name
    
    Open "C:\Scvrtemp\Authorize" For Input As #1
    Open "C:\Scvrtemp\Authorize_Revised" For Output As #2
    
    While Not EOF(1) Or Floppy_Update_String <> ""
        Line Input #1, StrHold
        If Mid(StrHold, 74, 12) = Left(Floppy_Update_String, 12) Then
            StrHold = Left(StrHold, Len(StrHold) - 1) & "Y"
            If Floppy_Update_String <> "" Then
                Floppy_Update_String = Right(Floppy_Update_String, Len(Floppy_Update_String) - 12)
            End If
        End If
        Print #2, StrHold
    Wend
    
    Close #1
    Close #2
    
    FileCopy "C:\SCVRTemp\Authorize_Revised", File_Name
    
    Kill "C:\SCVRTemp\Authorize_Revised"
    
    End Sub
    Mudfish AKA Bowfin
    I can spell "If" all day right, just a coder!


    "Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut." -- Ernest Hemingway

    Member of the ECCC

Posting Permissions

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



Click Here to Expand Forum to Full Width