What exactly you are looking for, because macro will not work. VB script will work for that. But it is not secure.
You can use filezilla to upload files from your computer to ftp server using your credientials.