Create a txt file from the data in the excel sheet

[Nyepalo]

Hello,
I need your help to export to a text file the information in the sheet "Detail".
- The Head of the text file is in my script. Only the date in that header changes, it is the day wich the text file is created.
- Records detail (0602): There are many records as rows in the Sheet.
- A total record (0802): This is the last of the table and it is described only once in the text file.

The empty spaces are part of the txt file and space should match the field length considering a space is a character.
As below

The reserve1 field = String (8, Chr (160).

Sorry for my English.

Regards.

[Leith Ross]

Hello Nyepalo,

Welcome to the Forum!

This macro will output the worksheet data to a text file. Pass the file path and name when you call the macro.

Example:

Please Login or Register  to view this content.

Macro Code

Please Login or Register  to view this content.

[Nyepalo]

Hi Ross,

Thank you very much for your speed, it's perfect, exactly what I was looking for, thank you again

I want also to integrated the header line in the file.txt. The Header line is one record and contains data that does not change except for the date of file creation witch is in the jjmma. I tried to fit it in your script, I didnt succeeded.
See my code

Please Login or Register  to view this content.

Regards.

[Leith Ross]

Hello Nyepalo,

Your change was close to correct. Here is the macro with your header code added. The header appears to be longer than 160 characters. Is it supposed to wider than the other lines?

Please Login or Register  to view this content.

[Nyepalo]

Hi Ross,
The header is not more than 160 caracters.

The Script should be :

Please Login or Register  to view this content.

I must add the current date in the header like ddmma :

Please Login or Register  to view this content.

But is not corect because the result is 925 it must be 09025.

Please Login or Register  to view this content.

Thanks.

[Leith Ross]

Hello Nyepalo,

Is the jjmma today's date? That is the date the macro is run? Or does this date come from someplace else in the workbook?

[Nyepalo]

That is the date the macro is run ? Yes

[Leith Ross]

Hello Nyepalo,

This should work...

Please Login or Register  to view this content.

[Nyepalo]

Hello Ross,

You're fantastic, everything is in order as I wanted. Thank you very much

God bless you.

[Leith Ross]

Hello Nyepalo,

You're welcome.

[Nyepalo]

Hi Ross,

I still need your precious help for my text file coming from the data in the Worksheet.
The text file contains the return line after the total record, I want this return line automatically deleted when creating texte file. How can I do ?

Regards.