Forum Discussion

asantos2021

Copper Contributor

Nov 30, 2021

Solved

Why is adding hyperlinks using VBA failing?

Hello, Could you assist me in finding where the flaw is? The data is as follows: A B C D E F G to Populate Ticker Data1 Data2 Data3 Data4 URL AMD https:/...

excel

Macros and VBA

HansVogelaar
Nov 30, 2021
asantos2021

I see two serious problems:

1) The URLs contain #. Excel cannot handle URLs that contain #.

2) The URLs are extremely long - up to 4812 characters in length. I'm not sure Excel can handle that.

If I try to convert the values in column G directly to hyperlinks, they don't work...

I'm afraid I don't have a solution for you, sorry.

asantos2021

Copper Contributor

Nov 30, 2021

HansVogelaar Thanks a lot, but I still get the same error:

HansVogelaar

MVP

Nov 30, 2021

asantos2021

Could you attach a sample workbook that demonstrates the problem (without sensitive data)?

asantos2021
Copper Contributor
Nov 30, 2021
HansVogelaar of course.
Stock Screener V3.xlsm53 KB
- HansVogelaar
  MVP
  Nov 30, 2021
  asantos2021
  
  I see two serious problems:
  
  1) The URLs contain #. Excel cannot handle URLs that contain #.
  
  2) The URLs are extremely long - up to 4812 characters in length. I'm not sure Excel can handle that.
  
  If I try to convert the values in column G directly to hyperlinks, they don't work...
  
  I'm afraid I don't have a solution for you, sorry.
  - asantos2021
    Copper Contributor
    Nov 30, 2021
    I didn't think we'd stumble upon this. Appreciate your time and the contributions you've made to the community through the years! All the best! Dank y wel.