+ Reply to Thread
Results 1 to 4 of 4

Version Control in Excel

  1. #1
    David
    Guest

    Version Control in Excel

    I'm working on a large spreadsheet which lets say is work in progress and
    therefore I have to resave it each time it is updated under a different name
    to distinguish between each saved copy.

    Is it possible to set up the Excel file so whenever I go into it it creates
    a new saved file with a dated reference, so I have a full audit trail (i.e.
    historical log) in date order automatically.
    --
    David

  2. #2
    Gazeta
    Guest

    Re: Version Control in Excel


    Użytkownik "David" <David@discussions.microsoft.com> napisał w wiadomości
    news:2F7BBD8B-BFDB-484F-A1AB-7FE68AF4A061@microsoft.com...
    > I'm working on a large spreadsheet which lets say is work in progress and
    > therefore I have to resave it each time it is updated under a different

    name
    > to distinguish between each saved copy.
    >
    > Is it possible to set up the Excel file so whenever I go into it it

    creates
    > a new saved file with a dated reference, so I have a full audit trail

    (i.e.
    > historical log) in date order automatically.
    > --
    > David


    try
    Private Sub Workbook_BeforeClose(Cancel As Boolean)
    With ActiveWorkbook
    .Save
    filepath = .Path
    .SaveAs filepath & "\your name " & Date & ".xls"
    .Close
    End With
    End Sub
    mcg




  3. #3
    David
    Guest

    Re: Version Control in Excel

    Excuse my ignorance but where do I type what you have written. What is
    Private Sub Workbook.

    I'm obviously not very proficient in Excel so please walk me through it.

    Thanks
    --
    David


    "Gazeta" wrote:

    >
    > UÂżytkownik "David" <David@discussions.microsoft.com> napisaÂł w wiadomoÂści
    > news:2F7BBD8B-BFDB-484F-A1AB-7FE68AF4A061@microsoft.com...
    > > I'm working on a large spreadsheet which lets say is work in progress and
    > > therefore I have to resave it each time it is updated under a different

    > name
    > > to distinguish between each saved copy.
    > >
    > > Is it possible to set up the Excel file so whenever I go into it it

    > creates
    > > a new saved file with a dated reference, so I have a full audit trail

    > (i.e.
    > > historical log) in date order automatically.
    > > --
    > > David

    >
    > try
    > Private Sub Workbook_BeforeClose(Cancel As Boolean)
    > With ActiveWorkbook
    > .Save
    > filepath = .Path
    > .SaveAs filepath & "\your name " & Date & ".xls"
    > .Close
    > End With
    > End Sub
    > mcg
    >
    >
    >
    >


  4. #4
    Gazeta
    Guest

    Re: Version Control in Excel


    Użytkownik "David" <David@discussions.microsoft.com> napisał w wiadomości
    news:0496E056-4396-4C62-AB4D-9C613BD7B20F@microsoft.com...
    > Excuse my ignorance but where do I type what you have written. What is
    > Private Sub Workbook.
    >
    > I'm obviously not very proficient in Excel so please walk me through it.
    >
    > Thanks
    > --
    > David
    >
    >
    > "Gazeta" wrote:
    >
    > >
    > > U?ytkownik "David" <David@discussions.microsoft.com> napisa3 w

    wiadomo?ci
    > > news:2F7BBD8B-BFDB-484F-A1AB-7FE68AF4A061@microsoft.com...
    > > > I'm working on a large spreadsheet which lets say is work in progress

    and
    > > > therefore I have to resave it each time it is updated under a

    different
    > > name
    > > > to distinguish between each saved copy.
    > > >
    > > > Is it possible to set up the Excel file so whenever I go into it it

    > > creates
    > > > a new saved file with a dated reference, so I have a full audit trail

    > > (i.e.
    > > > historical log) in date order automatically.
    > > > --
    > > > David

    > >
    > > try
    > > Private Sub Workbook_BeforeClose(Cancel As Boolean)
    > > With ActiveWorkbook
    > > .Save
    > > filepath = .Path
    > > .SaveAs filepath & "\your name " & Date & ".xls"
    > > .Close
    > > End With
    > > End Sub
    > > mcg
    > >
    > >
    > >
    > >


    right click on sheets tab an choose show code
    than find in left window ThisWorkbook an double click it
    than to right window paste

    Private Sub Workbook_BeforeClose(Cancel As Boolean)
    With ActiveWorkbook
    .Save
    filepath = .Path
    .SaveAs filepath & "\your name " & Date & ".xls"
    .Close
    End With
    End Sub

    than press alt+f11 and save your file
    on closing it copy of the file will be saved as well with data stamp
    change "your name" to desired one
    mcg
    if still help needed - write
    mcg




+ 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