How to keep a link when copying and pasting?
Solved
Anonymwa
-
vlar Posted messages 2474 Status Member -
vlar Posted messages 2474 Status Member -
Hello everyone!
I often find myself copying and pasting texts that contain links.
I would like to know if it is possible to keep these links in the new document.
Well, they are present but I mean to update them...
I don't know if a solution exists... but I'm asking the question just in case!
Thank you in advance for your responses!!
Configuration: Windows XP / Internet Explorer 8.0
I often find myself copying and pasting texts that contain links.
I would like to know if it is possible to keep these links in the new document.
Well, they are present but I mean to update them...
I don't know if a solution exists... but I'm asking the question just in case!
Thank you in advance for your responses!!
Configuration: Windows XP / Internet Explorer 8.0
8 answers
Hello
It's hard to respond without more details...
Which software?
What version?
What types of links?
m@rina
--
- "On the office forum, we ask questions about office software..."
- "Oh really???"
It's hard to respond without more details...
Which software?
What version?
What types of links?
m@rina
--
- "On the office forum, we ask questions about office software..."
- "Oh really???"
Good evening,
I may have a solution, but for a site where you don't need to log in with a username and password to get the information.
In Excel 2003, you click on "Data" - "External Data" - "New Web Query." Then, you give it the website address, and click on "Import." After that, you click on the "External Data Range Properties" icon, and check "Refresh on file open." You select your column A, copy/paste it. You open Word 2003, click on "Edit" - "Paste Special" - "Unformatted Text" and check "Paste Link."
Each time you want to update the information, you will need to open the Excel 2003 file and then the Word 2003 file.
I’m not sure if this is the project you had in mind, but it’s true that without giving more information, it’s hard to guess what result you want.
GOOD LUCK...
I may have a solution, but for a site where you don't need to log in with a username and password to get the information.
In Excel 2003, you click on "Data" - "External Data" - "New Web Query." Then, you give it the website address, and click on "Import." After that, you click on the "External Data Range Properties" icon, and check "Refresh on file open." You select your column A, copy/paste it. You open Word 2003, click on "Edit" - "Paste Special" - "Unformatted Text" and check "Paste Link."
Each time you want to update the information, you will need to open the Excel 2003 file and then the Word 2003 file.
I’m not sure if this is the project you had in mind, but it’s true that without giving more information, it’s hard to guess what result you want.
GOOD LUCK...
Sorry for the lack of detail... In fact, it’s about Word 2007 and the goal is to copy-paste these Word documents while preserving hyperlinks to other Word documents.
I hope I was clear enough, but anyway, it seems impossible...
In any case, thank you very much for your responses!
I hope I was clear enough, but anyway, it seems impossible...
In any case, thank you very much for your responses!
Hello.
As I explained one day to another user of this forum, a hyperlink behaves like a plank you have placed on 2 bricks to cross a flooded street: If you move one of the bricks, your walkway no longer allows you to get to the other side...
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
As I explained one day to another user of this forum, a hyperlink behaves like a plank you have placed on 2 bricks to cross a flooded street: If you move one of the bricks, your walkway no longer allows you to get to the other side...
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
Thank you for this lovely metaphor!
I understand the principle of links and it seemed quite unlikely to me that a solution exists, however since I am not very skilled I thought I might be missing a solution and after all it didn't hurt to ask more experienced people!
I will try to find another solution to my problem then other than links!
Thank you all!
I understand the principle of links and it seemed quite unlikely to me that a solution exists, however since I am not very skilled I thought I might be missing a solution and after all it didn't hurt to ask more experienced people!
I will try to find another solution to my problem then other than links!
Thank you all!
Hello.
I seem to remember that hyperlinks are preserved if the source file and the target files remain in the same folder, and that it is the whole folder that is moved. But I've never had the chance to check ... So if your copy-paste is done in the same folder, it might work (the board would be placed on a brick next to the previous one). And what if you used "Save as" instead of "Copy-paste"? It's worth a try. But I can't guarantee anything.
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
I seem to remember that hyperlinks are preserved if the source file and the target files remain in the same folder, and that it is the whole folder that is moved. But I've never had the chance to check ... So if your copy-paste is done in the same folder, it might work (the board would be placed on a brick next to the previous one). And what if you used "Save as" instead of "Copy-paste"? It's worth a try. But I can't guarantee anything.
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
Good evening,
This is valid for so-called "relative" links, which determine the location based on an entry point on a computer ---> a folder
For example, a note in a subfolder of my documents can be written
/Folder/note.txt ---> relative (to my documents in this case) (the file that calls the note must be located in my documents)
or
C:/blablalbal/My Documents/note.txt --> absolute (any computer with a file placed anywhere can open the note with this link)
Well, the example is bad since the "blabla" contains the username, but the principle is there
In the case presented, it seems that she wants to keep the hyperlinks pointing to the web in [http://] when copying text containing them.
The problem is that the copy function only takes what is visible (text and formatting); if the link is not written in HTML ("<a href= "monsite.com" />" there is no chance to retranscribe it into text.
However, assuming that we can do anything in IT, there must be a small utility that allows it, but I don't know of any...
Best regards
This is valid for so-called "relative" links, which determine the location based on an entry point on a computer ---> a folder
For example, a note in a subfolder of my documents can be written
/Folder/note.txt ---> relative (to my documents in this case) (the file that calls the note must be located in my documents)
or
C:/blablalbal/My Documents/note.txt --> absolute (any computer with a file placed anywhere can open the note with this link)
Well, the example is bad since the "blabla" contains the username, but the principle is there
In the case presented, it seems that she wants to keep the hyperlinks pointing to the web in [http://] when copying text containing them.
The problem is that the copy function only takes what is visible (text and formatting); if the link is not written in HTML ("<a href= "monsite.com" />" there is no chance to retranscribe it into text.
However, assuming that we can do anything in IT, there must be a small utility that allows it, but I don't know of any...
Best regards
Hello everyone,
My problem wasn't about links redirecting to the web but simply links to open other Word documents.
So I tried writing the link with the complete path and it works perfectly well!!!
In fact, the solution was really simple! I'm so annoyed I didn't think of it myself!
Anyway, thanks to everyone and an extra little thank you to Vlar!
Wishing you all the best!
My problem wasn't about links redirecting to the web but simply links to open other Word documents.
So I tried writing the link with the complete path and it works perfectly well!!!
In fact, the solution was really simple! I'm so annoyed I didn't think of it myself!
Anyway, thanks to everyone and an extra little thank you to Vlar!
Wishing you all the best!