Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

This Forum's HTML Link

0

I can't get the HTML link in this forum to work. These are the steps I take.

  1. I go to the website I wish to link to.
  2. Copy the URL from the address field acros the top of the screen to the clipboard.
  3. I select the text I want to show in the link, then click the "Add Link" button.
  4. Select the words "link_goes_here"
  5. Paste the URL copied in step 2

In this procedure the original URL is changed to the name the site has given to the link and this name appears instead of the address. What am I doing wrong?

Excel 365.

excelinternet-web
MS Office Version: 2010
posted by: Variatus (rep: 4889) on Sun Mar 28, 2021 at 8:25 pm
Answer
Discuss

Discussion

I think this must be something with the browser that is automatically converting the url into some other visible value. What browser and operating system are you using with this? And, do you use any browser extensions that might affect the link or copy/pasting values?
don (rep: 1989) Mar 29, '21 at 3:35 pm
Add to Discussion

Answers

0
Selected Answer

Variatus, this is a setting specific to the Edge browser from Microsoft and apparently it is the default behaviour - just tried it on mine for the first time and it does the same thing that you mention.

Here is the solution to get a regular link copied from Edge:

Open Microsoft Edge > Settings > Share, copy, and paste > click the "Plain text" option (there should only be two)

Now, you should get regular plain-text urls copied from Edge.

posted by: don (rep: 1989) on Tue Mar 30, 2021 at 8:19 am
Discuss

Discussion

Thank you, Don. That seems to have [LINK URL="edge://settings/shareCopyPaste"]cured it[/LINK].. Did it? Here's another attempt.
OK. So, your Link will not accept a local link. Fair enough.
Variatus (rep: 4889) Mar 30, '21 at 8:08 pm
You're welcome! I'm glad its working now! :)
don (rep: 1989) Mar 30, '21 at 10:34 pm
Add to Discussion
0

Variatus

When you paste the URL into the Add Link tags, you need to leave the inverted commas around the URL. This link Refurbished laptops UK 2021: Everything you need to know before buying a renewed laptop had this between the bounding tags:

LINK URL="https://www.expertreviews.co.uk/laptops/1407470/refurbished-laptops-where-to-buy"]Refurbished laptops UK 2021: Everything you need to know before buying a renewed laptop
 (and I took the webpage title (HTML) and used Paste as plain text over the Visible_Text part).

Hope this works for you.

John

posted by: John_Ru (rep: 6142) on Mon Mar 29, 2021 at 2:00 am
Discuss

Discussion

I'm leaving the inverted commas in place. [LINK URL="Need helping doing IF Formula using OR on macbook | TeachExcel.com"]Look at this answer[/LINK]. The problem is in how I copy the URL from the browser. By the time I paste it it's already changed.
Variatus (rep: 4889) Mar 29, '21 at 8:58 am
Variatus.

I'm puzzled since your "link_goes_here" part above isn't a URL.

This link Need helping doing IF Formula using OR on macbook was produced with this text (leaving out just the outer square brackets):
LINK URL="https://www.teachexcel.com/talk/5299/need-helping-doing-if-formula-using-or-on-macbook"]Need helping doing IF Formula using OR on macbook[/LINK
I went to that page, clicked in the (Chrome) browser URL bar, did Ctrl+C to copy then pasted the resultant https://www.teachexcel.com/talk/5299/need-helping-doing-if-formula-using-or-on-macbook between the inverted commas in the Add Link statement.

Does that not work for you? Or am I missing something?
John_Ru (rep: 6142) Mar 29, '21 at 9:40 am
Is this the one you were wanting to point the user to? Excel IF Statement – How to Use

Between the outer square brackets it's:
LINK URL="https://www.exceltrick.com/formulas_macros/excel-if-statement/"]Excel IF Statement – How to Use[/LINK
John_Ru (rep: 6142) Mar 29, '21 at 10:58 am
Yes and No. Yes, That's what I wanted. No, it didn't work for me. I am doing exactly what you describe and, frankly, I've been doing it in the same way for years. I'm using Edge, and even using Edge I'm accustomed to the correct result. I must have made a an unwitting change in the settings somewhere to have caused a change of behaviour.
Variatus (rep: 4889) Mar 29, '21 at 8:14 pm
That's odd. Took a quick look at Edge (mobile) settings but can't see anything that night alter that behaviour. Sorry I couldn't help you 
John_Ru (rep: 6142) Mar 30, '21 at 1:57 am
Thanks for trying, John. It's Microsoft. They make complicated things easy until easy things become complicated - and then they leave you alone
Variatus (rep: 4889) Mar 30, '21 at 7:03 am
Agreed- I moved to Microsoft 365 and just hate where they've put the search bar in Outlook 365 (though the searches are a bit faster, once you restore the Boolean operators Microsoft think you applied by accident!).
John_Ru (rep: 6142) Mar 30, '21 at 7:58 am
oh my gosh........... I have been avoiding Edge but just now tried copy/pasting a link and what you describe is the default behaviour!!!!!!!! Copy/pasting urls from Edge will paste in the website's title and a fully formatted url - wow - I'm happy keeping to Firefox and DuckDuckGo for searches lol.

Variatus, I did find the setting that you want to change: Microsoft Edge > Settings > Share, copy, and paste > click the "Plain text" option (there should only be two)

That should fix it. I'll also pop that into an answer in case someone else has this issue.

When that Outlook search bar was introduced without notification, just an update, it took me ages to find out where to go to search again... amazing how simple changes really mess with productivity!!!
don (rep: 1989) Mar 30, '21 at 8:16 am
Oddly I've been using duckduckgo with Edge (occasionally) on my desktop but getting the URLs AFAIK. I will check however- thanks Don. 
John_Ru (rep: 6142) Mar 30, '21 at 8:43 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login