VBA Refresh Linked Table in Excel from SharePoint List

[kwarden13]

I have a sharepoint list that is updated on the web. I need to refresh a workbook automatically using vba. I have the following code so far, however, I get a pop up to input the user credentials for sharepoint. How can I make this automatic?

Thanks
Sub mcr_refresh()
'
' mcr_refresh Macro
ActiveWorkbook.Sheets("Test").Activate
ActiveSheet.ListObjects("Test").Refresh
End Sub