VBA Copy Paste to Sharepoint

[ChoPaeng]

I need the masters help on this!

I want to automate our team attendance.

I have J5:J14 in my sheet where I want to copy and paste to the SharePoint's existing list.

There are 5 columns on the SharePoint's existing list and only 2 columns will be filled out.

 

[cerfani]

Re: [HELP VBA EXCEL] Copy Paste to Sharepoint

it sounds like you want to copy from one workbook and paste to another... more details would be needed for the actual code but here is an example...

Sub CopyPaste()
    Dim workbookCopy As Workbook, workbookPaste As Workbook
    Dim sheetCopy As Worksheet, sheetPaste As Worksheet

    'declare workbooks
    Set workbookCopy = Workbooks("CopyFrom.xlsx") 'workbook must be open in excel, edit the name
    Set workbookPaste = Workbooks("PasteTo.xlsx") 'workbook must be open in excel, edit the name

    'declare sheets
    Set sheetCopy = workbookCopy.Sheets("Sheet1") 'edit name
    Set sheetPaste = workbookPaste.Sheets("Sheet1") 'edit name

    'copy/paste
    sheetCopy.Range("J5:J14").Copy sheetPaste.Range("A1") 'edit where you want to paste

End Sub

 

[ChoPaeng]

Re: [HELP VBA EXCEL] Copy Paste to Sharepoint

we are using a SharePoint for our team to measure our Short Breaks and Lunch Breaks. I have my stopwatch running and what should happen is when the stopwatch resets, the data will be added to the SharePoint (not another workbook).