Open/Save/Close Workbook via command button

Hi. I have a command button that needs to open a workbook, save, then closed automatically. No need to display the workbook, this is because that workbook is connected to a sharepoint list and just needs to be opened to refresh the data. Workbook is set to "Refresh the data when opening the file".
I tried this code

Workbooks.Open Filename:="C:\Test.xlsx"

but it is displaying the last data from the excel, i still need to manually open the excel to refresh/update the data

Can you help me with the code? Thanks in advance!