Copying Links to Another File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 03 Apr 2008 12:08 GMT

Need help on how to copy linked cells into another file and keep the
links. I have several files which have links in them, need to combine
all into one file so we can autofilter through all entries. When I
copy over the data and paste, the link does not come with it. Tried
paste all and still does not work.

Any ideas?

Reply to this Message

Leo Rod - 03 Apr 2008 16:06 GMT

If the text on the cells are the same as the link location (AKA URL address)
use the function:
'Hyperlink' it turns general text from a cell into a hyperlink, if the
addreses are good it will become a valid link, once you're finished with all
the links, copy and paste "all" over that same set of cells and the formula
will be removed leaving only hyperlinks.

If you have "friendly names" and not valid URL with hyperlinks on it, we
should use a different approach.

Let the group know to see what solutions we can come up with.

Greetings

Leo Rod
MIA, FL.

> Need help on how to copy linked cells into another file and keep the
> links. I have several files which have links in them, need to combine
[quoted text clipped - 3 lines]
>
> Any ideas?

Reply to this Message

Tom - 03 Apr 2008 17:22 GMT

> If the text on the cells are the same as the link location (AKA URL address)
> use the function:
[quoted text clipped - 12 lines]
> Leo Rod
> MIA, FL.

That didn't work, but found something that did, though dose not make
sense. If I save "as is" in the folder above the existing links it
works. So I have to "save as" the original file to the folder which
has the other files I want to copy into, then I can copy the cells and
paste into my original file, then "save as' to the location of the
next file that has the files I want to copy the links, and so on.

Tom

Reply to this Message

Rate this thread: