Export TextBox object Value to txt file using VB macro

amirkachlon — Tue, 06 Oct 2015 15:26:30 GMT

Hi all,

I have single value string in a text bix object which I want to export into txt file,

anyone can help me with syntax?

Thanks alot

Amir

Re: Export TextBox object Value to txt file using VB macro

petter — Tue, 06 Oct 2015 20:22:13 GMT

You can export the text along with a lot of other properties of the TextBox by doing this:

Sub myExport

ActiveDocument.GetSheetObject("TX01").WriteXmlPropertiesFile "d:\temp\textbox.xlm"

End Sub

You will have to pick out the text by finding what is enclosed by <Text> and <v> tags... the XML-file contains hundreds of lines:

....

.....

<Text>

</Text>

.....