Macro Help

[#1]

..

[diegofcaivano]

Hi. I would recommend you to keep the VBScript code as light and simple as possible, so try to calculate the result in a QlikView variable first.

In this case create a new variable:

=[Field 1] & PURGECHAR($(Variable1), '/') & [Field 2] & CHR(13)

The 'Carriage Return' here is the 13th ASCII non-printable character.

Regards.

[#3]

Hi Diego,

To do so, i declared a variable in my scipt, but how can i use it in the macro

Something like

x = vName

msgbox vName

doesn't display my variable

I hope you can help

best regards

chris

[diegofcaivano]

Chris,

To get a QlikView variable at macro runtime, you need:

ActiveDocument.Variables("vName").GetContent.String

Cheers,

Diego.-

[#5]

Diego,

Thank you very much for your quick answer.

Do you know how i can add a suffix to a filename.

I use Filename = ActiveDocument.Evaluate("replace(documentname(), '.qvw', '.xml')")  to get a .xml file named after qvw but i'd like to add a country code like DocName_FR.xml, DocName_SP.xml  according to the selected country.

best regards

Chris