Excel macro and FTP mapping

[mart10]

I am using Excel 2003 on windows XP . I need to save a file onto a remote server which is connected via FTP.you apparently cannot map in the normal way when using XP

The path is : ftp://206.151.160.10/

My macro contain a line of code which I would normally use :

ActiveWorkbook.SaveAs Filename:=SaveDir & SaveName and normally you would use a mapped location eg T:\xxx\xxx but I have to use the FTP location


On the front sheet of my workbook I normaly hold the location of where to put the files ie SaveDir , so I was hoping to put ftp://206.151.160.10/ in there and then the macro would pick it up

Sheets("Top").Select
SaveDir = Range("B21").Value
TrapFXRates

But the macro stops when it hit this line. Hope I am explaining this ok?

 

[SkipVought]

Hi,

I remember doing this sometime in the distant past. First you have to save the workbook on your hard drive or network. Then you use a File Transport Protocol (FTP) to Put the file in the desires location. Don't have that exact information any more, but I bet there's lots of FTP stuff out there.

I recall having an IE version that I coded to either GET or PUT a file.