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

Hi
This is a normal behaviour, since your are copying cells with formulas.
And these formulas cannot calculate on your new workbook.
You should use this method instead:
Range("A3:A10").Copy
Workbooks.Add
ActiveSheet.Range("A1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False

HTH
Cordially
Pascal

"fth" <(E-Mail Removed)> a écrit dans le message de news:
80A98CCE-14E0-42F4-95E6-(E-Mail Removed)...
> 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
>

Thanks,

much better ;-)


"papou" wrote:

> Hi
> This is a normal behaviour, since your are copying cells with formulas.
> And these formulas cannot calculate on your new workbook.
> You should use this method instead:
> Range("A3:A10").Copy
> Workbooks.Add
> ActiveSheet.Range("A1").PasteSpecial Paste:=xlPasteValues
> Application.CutCopyMode = False
>
> HTH
> Cordially
> Pascal
>
> "fth" <(E-Mail Removed)> a écrit dans le message de news:
> 80A98CCE-14E0-42F4-95E6-(E-Mail Removed)...
> > 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
> >
>
>
>