Simple FTP

[pekajo]

Hi,
What is the simplest vba way of FTPing html file to hosting.
Thanks for any help.
Peter

 

[theDBguy]

Not sure if this is simple, but take a look.

VBA Download / Upload File using VBA FTP - Analyst Cave

VBA FTP Download and Upload Files to FTP servers with VBA. Uploading files to FTP, Downloading files from FTP with VBA

analystcave.com

 

[The_Doc_Man]

Simplest might be to build a batch file using VBA and then run it via SHELL. Looks like there is less typing.

FTP command-line options are listed here:

ftp

Reference article for the ftp command, which transfers files to and from a computer running a File Transfer Protocol (ftp) server service.

docs.microsoft.com

You would simply build a file with text lines such as

FTP
OPEN computer port
<<<<probably will have to put a password here for logging in to the target computer>>>>
TYPE <<<<either ASCII or BINARY depending on what you are sending>>>>
CD <<<<set remote directory>>>>
LCD <<<<set local directory>>>>
PUT filename    <<<<or could be GET filename>>>>
DISCONNECT
QUIT

Of course, where I've got things in <<<<>>>> you need to substitute appropriate values.
This would do the job. Note, however, that SHELL runs things asynchronously so MIGHT finish either before or after Access does whatever it was supposed to do.