Code to send sheet to FTP site

[Gareth]

I have a file and need to save one sheet in it as a .csv
file and then send it to an FTP site.

I have been able to save the file to my C drive and then
manually connect to the site and drag and drop the file.

What I want to be able to do is automate the complete
process, one click creates the file and logs on to the
site and 'puts' it there.

I would be very grateful for any pointers.

Many thanks.

Gareth

 

[Guest]

Gareth,
I had to do a simular process and did not have a lot of time to learn the Winsock control so I purchased a 'FileTranser' control from Catalyst software which made it very easy. Now that I know more about the winsock control and given the fact that it is standard Microsoft stuff, I would have build the FTP client into my Excel VBA with the winsock control.
-K

 

[Manuel Arias]

I am working on something like that too and I discovered that there is
a simple way to do it (I use EXCEL 2002).
I won't give you any code (Excel will do it itself)
Go in "Save as" and on the topleft (the 'SAVE IN' field)
scroll down and you'll see "FTP Locations" then create the ftp account
you need.
then you just have to start a macro and simulate the 'save as' process
then you'll got your code

ps : you can also have a look in Excel's Help [F1] !

Hope it helps (it did for me)