Discussion Board for collaboration on QlikView Layout & Visualizations.
Send to Excel I get this which is what I want:
Using Macro I get this:
how do I get the macro to force it to text?
If you have that number in a TextObject you could use this:
Set z = ActiveDocument.GetSheetObject("TXyourtextID")
Or you could set a variable with your value and the use this at the macro to get the value as String:
varValue = ActiveDocument.Variables("yourVariableWithTheValue").GetContent.String
There are a few ways to do it, just try or search "convert to string vbs" in google
Hope this helps, regards