P
pdberger
Good morning --
I have a user workbook that I want to have retrieve 40-50 pieces of
reference data from a central file on an ftp site. I have a 'workbooks.open'
command to open that file when the user workbook opens. However, then I get
an error message saying that "the Internet informs us that the file isn't
available."
I can think of several things going wrong --
* the ftp site is password-protected, and I haven't had a chance to write
in my user ID and password. If so, I don't know how to include that in the
command.
* I don't know whether to use "/" or "\" in the file address. It seems
sometimes it's one and sometimes it's the other.
* I don't know if I need to put in a "workbook.updatelink" or
"Workbook.UpdateRemoteReferences" command after opening the remote file.
Any advice would be appreciated, and thanks in advance.
I have a user workbook that I want to have retrieve 40-50 pieces of
reference data from a central file on an ftp site. I have a 'workbooks.open'
command to open that file when the user workbook opens. However, then I get
an error message saying that "the Internet informs us that the file isn't
available."
I can think of several things going wrong --
* the ftp site is password-protected, and I haven't had a chance to write
in my user ID and password. If so, I don't know how to include that in the
command.
* I don't know whether to use "/" or "\" in the file address. It seems
sometimes it's one and sometimes it's the other.
* I don't know if I need to put in a "workbook.updatelink" or
"Workbook.UpdateRemoteReferences" command after opening the remote file.
Any advice would be appreciated, and thanks in advance.