In depth FTP question.

I'm using the following code (found elsewhere in this forum) to upload a temp file to an ftp site:

Please Login or Register  to view this content.

It works perfectly.

However, is there a way I can specify a sub directory of my ftp server? I've tried hostfile = "\\subdir\subdir\filename" but then I just get a weird file in the root of the ftp server called \\subdir\subdir\filename.


Thanks in advance.

Hi swoop99,

I have no idea BUT....

Put an Option Explicit above your code and see if it compiles. The reason is that you have the Dim hostfile as String remarked out in your code above.

But why so complicated.
Excel has a builtin facility to put any file on a webserver.

You can add that location as an FTP-location in the SaveAs subwindow (scroll down completely).
After having added the location you can ftp any workbook using

Please Login or Register  to view this content.

Firstly, I dont want to upload the workbook (it's 32mb), I need to upload another workbook that's temporarily created with data in it and then deleted after the ftp upload.

Secondly, it needs to happen with no user intervention to a secure location and the one line command you list above suggests users would need to input username and password. EDIT: Oh and to prevent users screwing around with my workbook I've disabled 'saveas' and placed code in various places to ensure the workbook is always opened as read only and even if it is open with read/write access it'll make sure the loading screen is selected if someone saves it.

And thirdly, I had no idea the facility existed until you posted.