Hi Gareth,
This site might help you, Charlie Balch
http://charlie.balch.org/hdoc/exceltohtml.html

though it is designed for creating HTML and putting
the HTML with student grades to a website.

I referenced the above on my xl2html.htm web page.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gareth" wrote in message ...
I have a macro in a file which the user will run to create
a .csv file.

What I want to automate (as much as is possible) is the
transfer of this file from the users C drive to an FTP
site.

Working with DOS is totally alien to me so I wondered if
someone could give me a BIG pointer in the right direction.

I have visions of the user clicking a button, user form
pops up so that the username and password can be entered
and that's about as far as my vision goes at the moment.

PLEASE HELP!

Gareth