Re: excel: import txt files

From: jeff.pilant

Date: 24 Sep 2003

P�hringer Christian < writes:
>I have several *.txt files and i have to open them into one single
workbook.
>Each txt-file should appear in one worksheet.
>
>I know the following statement
>chworkbook = chexcel:workbooks:OPEN("c:\temp\test.txt").
>but when i use this statement for each usage of this command i open a
>workbook for each txt file.

Try something like the following:
      chWorkbook1 = chexcel:workbooks:OPEN("c:\temp\test1.txt").
      chWorkbook2 = chexcel:workbooks:OPEN("c:\temp\test2.txt").
      chWorkbook2:Sheets(1):Copy(, chWorkbook1:Sheets(1)).

/jeff