With help from rlv01 (I cannot THANK YOU enough), I was able to get a Word macro to convert plain text links to hyperlinks (Converting All Plain Text Links to Hyperlinks ). I was never able to get that to work in an Excel macro, which would be much better.
I am having issues getting this to operate across the network for other users. I placed the lettertemplate.dotm on a shared network drive. When another user attempts to generate a letter, it gives a "Run-time error -214735253 Can't run the specified macro." I open the Word template and look at macros, it shows, for me, in both the Normal and TemplateProject headings as Module 1. When I have a co-worker look at it, she sees TemplateProject Module1 and the Public Sub Hyperlink() code.
The code used to execute the Word macro from Excel macro: appWD.Application.Run "Module1.Hyperlinker"
What is happening that it is not working for other users from a network drive? How do I fix it?
Could the code that rlv01 wrote be converted to run against the Word document from Excel? This would be the best solution as then no Word templates or calls to external macros in Word would be needed.
I am having issues getting this to operate across the network for other users. I placed the lettertemplate.dotm on a shared network drive. When another user attempts to generate a letter, it gives a "Run-time error -214735253 Can't run the specified macro." I open the Word template and look at macros, it shows, for me, in both the Normal and TemplateProject headings as Module 1. When I have a co-worker look at it, she sees TemplateProject Module1 and the Public Sub Hyperlink() code.
The code used to execute the Word macro from Excel macro: appWD.Application.Run "Module1.Hyperlinker"
What is happening that it is not working for other users from a network drive? How do I fix it?
Could the code that rlv01 wrote be converted to run against the Word document from Excel? This would be the best solution as then no Word templates or calls to external macros in Word would be needed.