FTP information retrieval
 

Hi,

I am making a an Excel spreadsheet which has a few cells which need to
query some information from another Excel file located on an FTP
server.

In order to do this I set the relevant cell in my spreadsheet to
"=[name of the spreadsheet on the ftp site]cell coordinates". I do
this by opening the spreadsheet on the FTP server in excel (when I
open it through explorer, I get an embedded spreadsheet inside IE and
I can't seem to copy and paste the relevant information) and copying
and pasting the relevant cell.

The problem I encountered is that the relevant cell in my spreadsheet
fails to update (404 - file doesn't exist), the interesting thing it
does update if I open a copy of the spreadsheet on the FTP server with
the source information.

I am using Excel 2003 SP2.

In general, I wondering if anyone could suggest a way to retrieve
information from a cells in spreadsheet located on an ftp server?
Optimally, my spreadsheet should be able to update as long as it has
access to the internet.

FTP information retrieval
 

On Jun 12, 3:11 pm, wintermute wrote:
Hi,

I am making a an Excel spreadsheet which has a few cells which need to
query some information from another Excel file located on an FTP
server.

In order to do this I set the relevant cell in my spreadsheet to
"=[name of the spreadsheet on the ftp site]cell coordinates". I do
this by opening the spreadsheet on the FTP server in excel (when I
open it through explorer, I get an embedded spreadsheet inside IE and
I can't seem to copy and paste the relevant information) and copying
and pasting the relevant cell.

The problem I encountered is that the relevant cell in my spreadsheet
fails to update (404 - file doesn't exist), the interesting thing it
does update if I open a copy of the spreadsheet on the FTP server with
the source information.

I am using Excel 2003 SP2.

In general, I wondering if anyone could suggest a way to retrieve
information from a cells in spreadsheet located on an ftp server?
Optimally, my spreadsheet should be able to update as long as it has
access to the internet.

Anyone?