Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA FTP
I've tried several .bat examples and the MS INET for doing an FTP transfer
using Excel VBA and so far none of them work. Does anyone have a code snippet? The simpler the better:) Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA FTP
"DownThePaint" wrote in message
... I've tried several .bat examples and the MS INET for doing an FTP transfer using Excel VBA and so far none of them work. Does anyone have a code snippet? The simpler the better:) Thanks, Dim inet1 As InetCtlsObjects.inet Set inet1 = New InetCtlsObjects.inet With inet1 .Protocol = icFTP .URL = "ftp://ftp.private.com" .UserName = "George Washington" .Password = "no_lies" .Execute , "CD gifs\thegifs" .Execute , "PUT C:\source.txt target.txt" .Execute , "CLOSE" End With Set inet1 = Nothing That's an example from MSDN VB5, it works for me in Excel. -- roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|