Need help using a VBAscript in excel

[test]

I need help :-(

In this article there is a script to upload a file via FTP in VBA.
http://www.naterice.com/articles/51

What I want to do is run this script with a pushbutton or when the
file get's closed.

I'm new to VBA, and the part where they tell me to supply the
information is confusing.

As I see it, I have to "open" the FTPupload and parse the information
about the server when I call for the script?

But how do I do this?
I have tried in Excel to past the code in the VBA-editor, but how can
I get a button to open this function with the information it needs?

I'm very, very new to this, any help is welcome!
Thanks

 

[Erik]

Insert a module in the visual basic editor. Paste your code there.

In order to use the function go to the ribbon in Excel and choose insert
function. Choose userdefined in category and your function: FTPDownload or
FTPUpload