How to automatically login and refresh a spreadsheet using a plug-in?

Hi. I have a requirement to automatically refresh a spreadsheet's data. I'm an Excel novice and have no idea how to do this automatically. To refresh the data in a manual fashion, I perform the foll...