Open file on password-protected FTP site

P

pdberger

Greetings --
I have one workbook that pulls reference data from another. I want many
users around the country to have their 'client' workbooks, opening up the
'source' workbook with the reference data stored centrally. That way, I only
need to update the 'source' workbook once.
I've written code to pull the reference data when the 'target' workbook is
opened. I'm now ready to move the 'source' workbook to the central location.
My IT guy tells me the best way is to put it on an FTP site, which he has
set up. However, that site is password-protected (although the file won't
be).
How do I write the code to get past the protection and open the file to
establish the links? Here's some sample vitals:

ftp path & file name: ftp://petersite.com/test.xls
site login: peter
password: coffee

Or should I be trying to store the file differently to make access more
effective?
Thanks in advance.
 
V

Vergel Adriano

try a URL like this:

ftp://peter:[email protected]/test.xls

you need to be careful though because you will be exposing the username and
password for everyone to see...
 
P

pdberger

Interesting! I tried it, and it failed. But then I just tried

Workbooks.open Filename:="petersite.com/test.xls"

and it opened fine! Got right past the password protection. Hmmmm.

Thanks for pointing me in the right direction.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top