Dear Experts,
How can I create a FTP hyperlink in Microsoft excel ?

1. You can press CTRL-K on a cell with data in it and create Hyperlink on the "address" line of the window that pops up.

2. In a blank cell, you can enter a Hyperlink formula with FTP characteristics:

=HYPERLINK("ftp://ftpservername.com")

1. You can press CTRL-K on a cell with data in it and create Hyperlink on the "address" line of the window that pops up.

2. In a blank cell, you can enter a Hyperlink formula with FTP characteristics:

=HYPERLINK("ftp://ftpservername.com")


No it's not working somehow,
I tried by this
=HYPERLINK("ftp://testftp.com")
Note:- my ftp name is "testftp"

Note:- My ftp address is 10.48.118.146, so I tried by this command also,
=HYPERLINK("ftp://10.48.118.146")

but not working, please suggest

I've never used FTP from within EXCEL, so what you're trying to do isn't obvious. A Hyperlink alone would only be part of the process, I imagine. Perhaps a filename is required, too?

See if any of these links are of help:

How to open documents from FTP site and save documents to FTP site with Office programs. (http://support.microsoft.com/default.aspx?scid=kb;en-us;290142)

XL2000: Using Microsoft Excel to Save a File to an FTP Site (http://support.microsoft.com/kb/211713)

OFF2000: How to Publish a Web Document to an FTP Site (http://support.microsoft.com/kb/237828)

OFF2000: Error Message "Cannot connect to the FTP server" When You Access an FTP Site (http://support.microsoft.com/kb/230560/)

OFFXP: Error Message "Cannot Connect to the FTP Server" When You Access an FTP Site (http://support.microsoft.com/kb/290228/it)

I've never used FTP from within EXCEL, so what you're trying to do isn't obvious. A Hyperlink alone would only be part of the process, I imagine. Perhaps a filename is required, too?

See if any of these links are of help:

How to open documents from FTP site and save documents to FTP site with Office programs. (http://support.microsoft.com/default.aspx?scid=kb;en-us;290142)

XL2000: Using Microsoft Excel to Save a File to an FTP Site (http://support.microsoft.com/kb/211713)

OFF2000: How to Publish a Web Document to an FTP Site (http://support.microsoft.com/kb/237828)

OFF2000: Error Message "Cannot connect to the FTP server" When You Access an FTP Site (http://support.microsoft.com/kb/230560/)

OFFXP: Error Message "Cannot Connect to the FTP Server" When You Access an FTP Site (http://support.microsoft.com/kb/290228/it)



Dear JBeaucaire,
Thanks for your kind help, reference links are very useful.

First let me clear what I am doing exactly, seems it is not much clear.. Sorry for that.
I have a xls in which for purticular predefined parameters I want to to extract the real time information(which is stored & Updated at ftp server), so I am giving hyperlinks in the xls to pick updated information directly from the ftp server (instead of sharing folders, which is not feasible & secure).

Now I am able to get the details from my internal domain, but I am not able to get the details from the ftp server, which is located in some another domain.
How to go about it, suggest.