Creating Working Archive Document

[red_jon]

Hi, im pretty new to excel and vba so please bare with me.

I want to create an archive workbook where I can keep adding tabs every month for reporting purposes.

I only want to copy one particular tab every month from my master workbook into the archive document. This being named as the current month i.e. "January" "February" "March" and so on....

Can anybody guide me to a way of achieving this? I been searching everywhere for the solution.

Note: Having both documents open at the same time is not a problem but would prefer it not to be.

Your help would be much appreciated.

Thanks,</SPAN>

 

[red_jon]

Hi Andrew,

This seems to do the job locally, however the files are saved on Sharepoint. Could you provide me with some code that would Check Out the document - copy the sheet - Check Back In - Close

Sub Archive_Report()
    Application.ScreenUpdating = False
    Workbooks.Open Filename:= _
        "\path....\archive.xlsm"
    Windows("Copy of Final test.xlsm").Activate
    Sheets("Summary Report").Select
    Sheets("Summary Report").copy Before:=Workbooks("archivexlsm").Sheets(1)
    ActiveSheet.Buttons.Delete
    ActiveSheet.Name = Format(Date, "Mmmm,d,yyyy")
    ActiveWorkbook.Save
    ActiveWindow.Close
    Application.ScreenUpdating = True
End Sub

 

[Andrew Poulsom]

Sorry, I know nothing about SharePoint.