| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create text file
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" a écrit dans le message de news: ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to create dbase file from text file? | Excel Discussion (Misc queries) | |||
| From Immediate window to Text file - create a log file | Excel Programming | |||
| Create text file | Excel Discussion (Misc queries) | |||
| how to create a new text file | Excel Programming | |||
| How to create a Text File ? | Excel Programming | |||
Hybrid Mode
