Here is the method that I have been using. I have had good luck with it.
I need to save a file to an FTP location automatically on a regular basis,
sometimes from different workstations.
The macro recorder in Excel shows the save as code happily, but does not
record the setting up of an FTP location beforehand.
Any help on how to set up an FTP location programatically from Excel VBA
would be very appreciated!