VBScript: Get the content of a text region ?

BurkhardDahl · ‎Jan 20, 2011

Hallo MathCad Collab,

is there a usable solution to get the content (value?) of a text region object in a VBScript worksheet.regions - loop like this:

Const mcTextRegion = 0

For each rg in Worksheet.Regions

If rg.Type = mcTextRegion Then

TextRegionString = rg.???????

......

End If

Thanks Burkhard

RichardJ · ‎Jan 20, 2011

Unfortunately, I don't think there is any way to do what you want. At least, not any easy way. I tihnk the only way to do it would be to read the entire XML of the file and parse it to find the desired text.

MikeArmstrong · ‎Jan 20, 2011

That could be done as Richards suggests, but why would you want to?

Can you provide a little more information or maybe a worksheet as there might be alternative routes to go down.

Mike

ifomenko · ‎Apr 24, 2018

I want to assign region.tag = region.text to automate the creation of a table of content (TOC).