Can anyone help with this?
I need to open a file and/or Refresh imported data from a file located on an
ftp server.
-I have added the location to my FTP Locations with needed user name and
password.
-I can "see" the file in the open file dialogue box
-However, on selecting file, an opening dialogue box opens for about 10
seconds and then stops with an error message saying cannot open file,
followed by another giving general reasons ie "file/path does not exist" or
"file in use by another prog.." or "file...same name as currently opened.."
(If I access ftp location via windows explorer I can open file or copy to my
computer, but want to automate process in an excel macro which will refresh
my imported data)
Any help would be appreciated.
Regards
Brian