>I'm automating a data migration task in wich i'm exporting data from a txt file to an excel sheet.
>Excel has an object called querytable, wich has an array property called textfilecolumndatatypes; this property stores a value for each column in the source file.
>In fact, something like:
>Myarray = MyQuerytable.TexFileColumnDataTypes
>returns an array, but (here's my problem)
>
>MyQuerytable.TexFileColumnDataTypes = Myarrray
>
>is not a valid statement (syntax error).
>So invalid are these other approaches:
>MyQuerytable.TexFileColumnDataTypes = Myarrray(1)
>MyQuerytable.TexFileColumnDataTypes(1) = '1,1'
>MyQuerytable.TexFileColumnDataTypes = '1,1'
>...
>
>How do I get to put some values in this property?
>
>TIA
Cristobal,
Use OpenText instead. Then you could pass an array by ref.
Check Message #
770668 Cetin