Macro in Word .dotm template not saving

[kckay]

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.

 

[Macropod]

There is no need to use a macro for this; it can all be done by the mailmerge itself. Hence, your template distribution problems can be obviated. See my reply in your other thread.

 

[kckay]

I am so confused by that write-up. How do I automate it? If it is a manual process to be done AFTER the letter is generated, then just using the normal Hyperlink ribbon button will be easier. If there is a way to automate it and do use mailmerge, how?

Are you saying to convert all of the simple text fields to mergefields within the template, then use mailmerge to bring in the hyperlinks? Won't that be the same issue I have now in that the hyperlinks don't because they are coming from Excel and are just simple plain text links?

The source text is coming from Excel. How do I create a mergefield in Excel text?

I am really sorry, but am confused. I really appreciate the help and want to learn. This look very promising for multiple users across the network.

 

[Macropod]

See my reply in your other thread.