hi,
anyone can help me to create pipe delimited text file from excel via macro?
attached is the excel source and output text file format.
the test file will have the following format:
|date|ID|WorkingDays|DaysPresent|AbsentHours|LateHours|PresentHours|
|yyyy-mm-dd|ID|13|12|0.00|0.00|96.00|
thanks,
You can use this code -
Please Login or Register to view this content.
Last edited by arlu1201; 02-03-2012 at 07:08 AM.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
thanks,
how do i add the row one after the other on the txt file, so far it create one row for all excel rows? my output should be:
|yyyy-mm-dd|ID|13|12|0.00|0.00|96.00|
|yyyy-mm-dd|ID|13|12|0.00|0.00|96.00|
|yyyy-mm-dd|ID|13|12|0.00|0.00|96.00|
The vbLF is the line feed character which will copy the data to the next line. I tested it at my end and it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks