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

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