+ Reply to Thread
Results 1 to 3 of 3

vba codes save files to path

Hybrid View

  1. #1
    Registered User
    Join Date
    09-21-2009
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    vba codes save files to path

    Hello,

    Anyone can help me!!!

    I have excel 2003 workbook that we used in daily transaction in our company.
    There are many times that my colleagues close the file without saving it.

    This is the filename 37week9.xls,
    and this is save at this path, T:\daily\work\transaction

    Anyone here have macro codes?
    1.) I want this file that will automatically save in every 10 minutes without clicking save and also automatically close the excel file.
    2.) If the file is closed this will save automatically.

    Thank you very much.
    Akou.

  2. #2
    Registered User
    Join Date
    12-14-2007
    Location
    Ontario
    Posts
    19

    Re: vba codes save files to path

    For the Every ten minutes, that's a built in function of Excel.
    You want to go to Tools --> Options --> Save (tab) and then set the autorecover time. You may also want to make note of the path.

    Also, for your second issue, if a document has been changed, An office application will prompt the user to save the document when they try to close it. So what you need to do is tell the staff to click yes when it asks if they would like to save changes on close.

  3. #3
    Registered User
    Join Date
    09-21-2009
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: vba codes save files to path

    Thank you excel_guy49...

    I dit it already. I want to have a macro command.
    I'm just a begginer in macro codes.

    Can you please make me a code on this in macro command?


    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1