actxserver makes a word document with a table of contents and i want to the table of contents to be a hyperlink to each section

I have created a matlab file that takes in a series of .xlsx files and using the actxserver functions creates a word docuement and fills it with a bunch of sections that each contain some number of graphs created using the .xlsx data. I have got it so that the MATLAB script creates the word document with a Table of Contents as there are quite a few sections. What i want now is to make each section listed in the table of contents a hyperlink to that section. I have used the UseHyperlink = True code but that has made no change. The Word document created is saved as both a word file and a PDF. I would like to have the hyperlinks working in both the Word and the PDF if possible.

[dpb]

Not a MATLAB Q? at all...and while I've done a fair amount with Excel, I've no experience/knowledge at all of Word.

But, in general, if you can figure out how to make something in Word, record a macro that does "that something" and then use the generated VBA code as a template to translate to activeX syntax...not always a mean feat, but eventually doable with enough perserverence.

[Duncan]

Well it is becasue all of this is being done in Matlab. at no point do i actually interact with word myself it is purely done in Matlab. I use the matlab functions to create the word. More the problem is making the Table of Contents act as a hyperlink. I have found syntax that goes with the ActXserver package to make the ToC hyperlinks but the syntax seems to be out of date as Matlab no longer detects this as a function.

[dpb]

I've never (and hope to never have to :J) tried to use any of the builtin Word interactive stuff; if there's an included Matlab function you're using that doesn't work, that's a support/bug issue directly with Mathworks support.

From the way you wrote the Q? I presumed you were using ActiveX directly in which case it is MATLAB only in that ML supports the ActiveX connection; the actual syntax is then whatever it takes to execute the VBA code.

If the problem is that of the first response above (a ML function that doesn't do what you think it should), the workaround could be the latter...

[Duncan]

I am using ActiveX within matlab but i am also using Matlab itself to process a large amount of data coming out of the Excel files. I suppose the hyperlinks part would be VBA syntax and i will ask again about this within the appropriate forum. Is there potentially any other way to make the ToC hyperlinks

[dpb]

I do a lot of processing in Matlab with data from/to Excel; I tried once to build an automated report with Word but soon gave that up as being far too painful. But, the same thing holds as before, open your Word document interactively and figure out how to do what you're trying to do...when you can do that, then record those steps in a macro and subsequently translate that VBA code to the equivalent with ActiveX. What happens is that you cannot always use the exact VBA code because many of the methods are composite methods at the VBA syntax level and Word macros have the VBA compiler to translate to actual code. But, working in MATLAB directly, the VBA compiler is not available and it isn't The Mathworks job to provide that functionality; you have to take those intermediate steps one at a time yourself. There really is no other way...

As you say, you may be able to find example code either in the VBA documenation for Word or from a user forum that will show you the way; then again, you may not--but, a search is always worthwhile; this sounds like something others would have tried to do programmatically so I'd guess there's a reasonable shot at least seeing demo VBA code (but far less likely to find a direct ActiveX translation you can just pick up and use).

[Les Beckham]

FYI

Here is a macro recorded when inserting a table of contents using Word 365. In case anyone has an idea of how to convert this VBA to ActiveX commands.

Sub InsertTOC()
'
' InsertTOC Macro
'
'
    Application.Templates( _
        "C:\Users\<username>\AppData\Roaming\Microsoft\Document Building Blocks\1033\16\Built-In Building Blocks.dotx" _
        ).BuildingBlockEntries("Automatic Table 2").Insert Where:=Selection.Range _
        , RichText:=True
End Sub

[dpb]

Here's the <link to the .Add method for a TOC> from the Word VBA reference.

You'll want to work your way back from the details to the general TOC info first, but there's everything there is that can be controlled programmatically via VBA, ergo ActiveX.

Good luck, if you thought the Excel object model was complicated, you ain't see'ed nuthin' yet when dig into Word.

ADDENDUM

"[Y]ou cannot always use the exact VBA code because many of the methods are composite methods at the VBA syntax level and Word macros have the VBA compiler to translate to actual code. But, working in MATLAB directly, the VBA compiler is not available"

Note especially that in looking at the example in the above VBA doc, in MATLAB using ActiveX, you cannot use named parameters as it does; the arguments to functions must be passed positionally. Any not needed in the argument list prior to one that is needed must be either passed with explicit values (look up default) or with an empty placeholder, [].

Also, one often must create a temporary variable that is the correct object type of which the method or property is a member so that "dot" addressing is only one level deep; the MATLAB parser doesn't know about possible dereferencing the VBA compiler will do so must help it along. Also, occasionaly one has to resort to using invoke to call a method; sometimes no other syntax seems to work; I've not ever been able to fully understand why in those cases, but it is all tied into what the VBA compiler does internally with VBA source code that simply isn't available to the MATLAB parser.

[dpb]

"...using the actxserver functions creates a word docuement and fills it with a bunch of sections ..."

Post the code you're using that does this and a sample (smallish) Word file that it works on--you may have to "cheat" to attach the Word file by renaming it to Word.txt to get around the forum restrictions.

The doc for the TOC and some responses on the MS support forum indicate the TOC is hyperlinked by default but it notes in response to several Q? about "Why isn't my...?" that you may need to use Ctrl-Click instead of just clicking on some platforms.