#Upload files to ftp via browser code

''Print #lInt_FreeFile01, 'recv Picture.gif ' & ThisWorkbook.Path & 'Picture.gif' '' To receive a file, replace the above line with this one Print #lInt_FreeFile01, 'send ' & ThisWorkbook.Path & 'Picture.gif' 'this is the location of your file to be uploaded

Print #lInt_FreeFile01, 'cd directory_folder_name_goes_here/sub_dir_name_etc' 'leave space after the word cd Print #lInt_FreeFile01, 'password_goes_here' Print #lInt_FreeFile01, 'account_name_goes_here' Print #lInt_FreeFile01, 'open ' 'leave space after the word open Open strDirectoryList & '.txt' For Output As #lInt_FreeFile01

'If Dir(strDirectoryList & '.out') <> '' Then Kill (strDirectoryList & '.out')

#Upload files to ftp via browser code

Hopefully someone knows a little bit about this and they can get me pointed in the right direction.Ĭreating new directory folders is my aim (unless someone has a code or knows an easier way to upload multiple folders within folders without a pre-existing FTP directory). To my knowledge, the code below will only grab a file if the directory is pre-existing on your ftp account.īecause of this, I was thinking maybe if I could somehow create a new directory tree, -I could then upload each file in accordingly. The only problem I'm running into is I would like to upload a folder with multiple sub folders and files. It enables you to upload files without the hassle of constantly opening and logging in to FileZilla or whichever FTP client you might be currently using. For anyone not familiar with this code below it's awesome and works perfectly.