Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test FTP Connection
How can I test to make sure my FTP connection is connected before I execute
my code. Thanks Grant ActiveWorkbook.SaveAs Filename:= _ "ftp://123.456.7.89/path/invoice.dat", FileFormat:=xlTextPrinter _ , CreateBackup:=False |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test FTP Connection
I use an ActiveX control from http://www.chilkatsoft.com/
Set chilkatFTP = CreateObject("ChilkatFTP.ChilkatFTP") 'FTP Parameters chilkatFTP.Hostname = hostip chilkatFTP.UserName = username chilkatFTP.Password = password 'Connect chilkatFTP.Connect 'Was the connection successful? If chilkatFTP.IsConnected Then 'DO SOMETHING Else 'DO SOMETHING ELSE End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
Change database connection between live and test for external data | Excel Discussion (Misc queries) | |||
test..where are my messages..test | New Users to Excel | |||
connection test | Excel Programming |