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")

Quote:

---

Originally Posted by JBeaucaire

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.

XL2000: Using Microsoft Excel to Save a File to an FTP Site

OFF2000: How to Publish a Web Document to an FTP Site

OFF2000: Error Message "Cannot connect to the FTP server" When You Access an FTP Site

OFFXP: Error Message "Cannot Connect to the FTP Server" When You Access an FTP Site

Quote:

---

Originally Posted by JBeaucaire

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.

XL2000: Using Microsoft Excel to Save a File to an FTP Site

OFF2000: How to Publish a Web Document to an FTP Site

OFF2000: Error Message "Cannot connect to the FTP server" When You Access an FTP Site

OFFXP: Error Message "Cannot Connect to the FTP Server" When You Access an FTP Site

---

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.