View Single Post
 
Old 01-22-2023, 05:23 PM
Big_Sugah Big_Sugah is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2023
Posts: 5
Big_Sugah is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
It would most likely be due to that. The sample you provided only had short URLs so we didn't anticipate much longer strings.

I assume the text file isn't changed often so it would be easier to edit that to split any of overly long lines by adding a paragraph mark in a logical location than it would be to add complexity to the vba code.

I would expect the maximum string length to be something around a power of 2 eg 64, 128 or 256 characters. You can hover your mouse over the Len(sFind) to see how big the unacceptable number is.
Hi Guessed,

Thanks for this, I just changed the script (That generates the .txt document) to cull links over 256
I've got one more question, it seems that the VBA macro will highlight any words separated by spaces. Is there a way to instead find and replace by the whole word?
For example if I had the word "Google Account Services" in the .txt document instead of Google, Account and Services being highlighted I only wanted occurrences of the entire word.
Reply With Quote