[YogeshS]

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

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

[YogeshS]

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

[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

[YogeshS]

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.