'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 |
|---|
