How to "From Excel to Text document with predefined spaces"

[zzaakk10]

Hi all,
I heard from a friend that this forum is very useful.
I am facing a problem, as i am not that good in programming.
i have one excel document containing information of employees, for some purpose i need to convert that information to a text document with some special format which will be loaded in Retail software. unfortunately the number of employees is huge that i can not do it manually or it will take months.

Employee Information to be loaded transferred to text document:
employee code, store code, employee name, surname 1, surname 2, post code.

Format in text document:
Employee code(8 digits) 8 blanks, then Store Code(4 digits) 3 blanks, then Employee name(20 characters) no blank, then Surname1(20 characters) no blank, then Surname2(20 characters) 15 blanks, then Post code. After this next line and same information for next employee.

You can see the attached pic also for what format i want in txt document.
If anybody can help, i will be really thankful.

Thanks

[ragulduy]

I don't know where on the document the information is stored but it would be something like:

Please Login or Register  to view this content.

You would need to set it up to loop through the different records but each time you use writeline it will put it on a new line.

[zzaakk10]

Hi Bro,
Thanks. Let me try

I don't know where on the document the information is stored but it would be something like:

Please Login or Register  to view this content.

You would need to set it up to loop through the different records but each time you use writeline it will put it on a new line.

[zzaakk10]

Hi,
It gives error "Object doesnt support this property or method"
Set txtFil = fs.createtxtFil("PATHNAME")

Thanks

I don't know where on the document the information is stored but it would be something like:

Please Login or Register  to view this content.

You would need to set it up to loop through the different records but each time you use writeline it will put it on a new line.

[ragulduy]

oops, should be createtextfile, not createtxtfile!
(you also need to change the pathname to somewhere on your computer, eg. "c:\data.txt"

[zzaakk10]

Hi,
Macro is runnign without giving error but there is no output file.

Thanks

oops, should be createtextfile, not createtxtfile!
(you also need to change the pathname to somewhere on your computer, eg. "c:\data.txt"