'How to open a file from server via VBA?

I want to open a file. I get an error that the address is wrong.

'Cannot connect to 192.000.0.00/system/employee.lst, Please check if the web address is correct'

Workbooks.OpenText Filename:="ftp://192.000.0.00/system/employee.lst", Origin:=932 _
  , StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
  ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _
  , Space:=False, Other:=False, _
  TrailingMinusNumbers:=True

When I try to open this address ftp://192.000.0.00/system/ with folder explorer there is no problem.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source