I'm looking to test an ftp connection from within Excel VBA. I am using the following code to open a file from an FTP but if there is no connection, Excel gets stuck:
" & Range("IP_Address_on_Box")
& "/FS_LS.log", Origin:= _
xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuo
e, Tab:=True, Semicolon:=False, Comma:= _
False, Space:=False, Other:=False, FieldInfo:=Array(1, 1), _
I've tried doing it without VBA by going through the menu system (File > Open etc.), but it still gets stuck and I have to close Excel using Task Manager.
Is there a way to test a connection over an ftp in advance of running this code?
Thanks in advance :_