Is it possible to FTP a file to my website within VBA?

I am not aware of any built in function that can do that, but maybe this workaround will help you

http://www.bygsoftware.com/Excel/VBA/ftp.htm

And maybe google for more...

Thanks for the suggestion, I had already sorted this by shelling to the FTP command line.

Basically created an FTP script file within VBA for the necessary instructions, then used shell to launch FTP.

t = Shell("ftp -s:path\ftpscript", 1)

Works OK for what i need.

Thanks