+ Reply to Thread
Results 1 to 2 of 2

Automatic saving of worksheet with unique names

  1. #1
    oystlars@gmail.com
    Guest

    Automatic saving of worksheet with unique names

    I have a computer running 24/7 and multiple people are writing items to
    a list (worksheet).

    It is important that it is saved several times a day, let's say at
    10am, 12am and 14am.. And preferably to a specific location and with
    uniqe filenames.

    I have come up with this so far:

    ThisWorkbook.SaveAs Filename:=3DFormat(Now, "yymmdd_h=ADhmmss") & ".xls"

    Can anybody help me out?

    Best regards, =D8ystein


  2. #2
    Ron de Bruin
    Guest

    Re: Automatic saving of worksheet with unique names

    Hi Řystein

    Maybe SaveCopyAs is a better option for you
    Your original workbook stay open and you save a copy in a
    different folder

    ThisWorkbook.SaveCopyAs Filename:="C:\Data\" & Format(Now, "yymmdd_h*hmmss") & ".xls"

    You can run the code automatic every two hours if you want
    Look here
    http://www.cpearson.com/excel/ontime.htm


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    <oystlars@gmail.com> wrote in message news:1126181128.280786.269710@o13g2000cwo.googlegroups.com...
    I have a computer running 24/7 and multiple people are writing items to
    a list (worksheet).

    It is important that it is saved several times a day, let's say at
    10am, 12am and 14am.. And preferably to a specific location and with
    uniqe filenames.

    I have come up with this so far:

    ThisWorkbook.SaveAs Filename:=Format(Now, "yymmdd_h*hmmss") & ".xls"

    Can anybody help me out?

    Best regards, Řystein



+ 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