Randomly saving a copy of a file in 'my documents'
Results 1 to 3 of 3

Thread: Randomly saving a copy of a file in 'my documents'
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    268
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Randomly saving a copy of a file in 'my documents'

    Hi All -

    I have a strange question here... not actually sure if the cause of the problem is Excel or Windows - but I figure if I ask the Excel gurus and you don't know then it might be a Windows thing!!

    I have a 'Summary' file that opens each file in a given folder, checks it for some info, saves the file (just a straight save) and then closes it.

    This does exactly as it is supposed to on 50+ computers. BUT - one person is having the following thing happen:

    When she runs the update in her Summary file, it does open each file in the correct folder, does everything it is supposed to, saves the file and closes it. BUT - it is also doing a SAVE AS and creating a copy of the file in her My Documents folder. This is NOT in the VBA code anywhere - there is no SAVE AS code, no COPY or MOVE code, nothing that would seem to be causing this behaviour.


    Has anyone seen such a thing? Could this be a corruption in the Excel code somehow??


    Thanks!!

  2. #2
    Board Regular
    Join Date
    Mar 2007
    Location
    Chicago Area
    Posts
    2,639
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Randomly saving a copy of a file in 'my documents'

    So you're saying that the save and close is only like this (with wkBk referring to a workbook object)?

    Code:
    wkBk.close True
    ...how do you know that the code is saving the file? Maybe the user is saving it in the documents folder?

  3. #3
    Board Regular
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    268
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Randomly saving a copy of a file in 'my documents'

    It just says...

    wbData.save
    wbData.close

    I originally assumed that she was moving them or touching things she should be, but I watched it happen... I deleted the files from the My Documents folder. Clicked the 'update' button in the Summary file, and all the files re-appeared in the My Documents folder.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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