Change selections in a export to excel macro

Mon, 26 Oct 2015 14:54:46 GMT

i'm exporting tables to an excel with this useful macro

Now i have to export a object with a selected value, and the same object with other selected value

I tried with this

set val=ActiveDocument.Fields("_ARS").GetPossibleValues

ARS = val.Item(val.Count-1).Text

ActiveDocument.Fields("MEDIDA_DESCRIPCION").Select ARS

after the part of exporting the object:

aryExport(0,0) = "FISICOxMARCA"

aryExport(0,1) = "Fisico x MARCA ARS"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

.... ( new code)...

(and i created an inline like this)

LOAD * INLINE [

_ARS, _UND,

ARS, UND

];

But if i use this the macro stop working

Any ideas?

Thank you

Re: Change selections in a export to excel macro

Mon, 26 Oct 2015 14:55:34 GMT

BTW: I know i could do it with more expressions with set analys, but they're a lot of objects.