Hi,

i have a workbook with 2 column;
column1 with
tata
toto
titi
column 2 with
=CONCATENATE("md """,A1,"""")

with this code,
Range("A3:A10").Copy
Workbooks.Add
ActiveSheet.Past

ActiveSheet.SaveAs "C:\UserTemp\MD_Designation2.bat",
FileFormat:=xlTextWindows
ActiveWorkbook.Close

the result is:
tata
toto
titi

but if I take column with concatenate:

the result is
REF
REF
REF..

what's wrong?

best regards,

Frederic