Display of folder on FTP site

[Ed]

I have a folder on my FTP site that has documents that I wish to share with
others. I would like them to be able to simply click a button on a Word form
and the folder will open up. I recorded the following steps:

File|Open

(I then typed the following into the FileName box of the resulting dialog)

ftp://ftp.mysite.com/htdocs/ShareDoc/Docs/

(I then pressed Open and all files displayed.)
==========
All good so far.

I went to the macro editor and recovered the following code

ChangeFileOpenDirectory "ftp://ftp.mysite.com/htdocs/ShareDoc/Docs/"

I pasted the above code into a Sub attached to the button. When VBA runs the
line, I get an error 4172 (Path not found).

Is there a way to do this differently so it will work?

Thanks,

Ed

 

[Ed]

Okay, let me ask a slightly different question. Is there a way, using
SendKeys to open the FileOpen dialog and then to type for me the keys to
activate the FTP folder.

Here is what I composed, but it doesn't seem to work. (I must have an error
somewhere because even SendKeys "^O" doesn't display the FileOpen dialog. I
hate being so stupid about this, but there must be a way. . . .)

SendKeys "^Oftp://ftp.mysite/htdocs/ShareDoc/Docs/"

This doesn't work either:
SendKeys "^O"
SendKeys "ftp://ftp.mysite/htdocs/ShareDoc/Docs/"

Any guidance would be greatly appreciated.

Thanks.


Ed

================

 

[Ed]

OOOPPPPSSSSS!!!! Forget my second post in this conversation. When I was
testing the SendKeys routine, I was stepping through it in the VBA editor.
Can't do that. I assigned the macro to a menu and it works just fine.

Sorry.

Ed