Take a look at this code:
http://www.bygsoftware.com/Excel/VBA/ftp.htm

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Jari Toukkari" wrote in message
...
Hi

I would like to send a file to a certain ftp address. It looks like it
works
fine using Access, but I do a lot of stuff with Excel and it would be
great
to implement ftp to my Excel "toolbox".
Typical situation is that after cleansing a file, it is saved as .csv and
if
possible, I would like to send the .csv which is open at the same time, to
a
certain ftp address. Alternative for that would be that a certain file or
all files in a folder would be send immediately or frequently.

Is that possible?

If some of you gurus know the answer, I would be grateful. Could you also
send the reply to my email as I don't always have
access to news groups.

Thanks
Jari