morsi wrote:
Do you know any tutorial which explain the DDE message
([open.text("%1",,,,,,0,0,0,0,1,"|")] ) syntax ?

Now, I would like to automatically save the file with the specific
delimitor et extension.

i have not seen any other document. i referred to the help file and
followed other predefined actions.

perhaps excel cannot output a text file with a specific delimiter that
is not built-in, by itself.
this is an example of a macro:

Procedure to export a text file with both comma and quote delimiters in Excel
http://support.microsoft.com/default...b;en-us;291296

--
HTH,

okaizawa