Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to extract data in .txt format from the excel sheet in a fixed length ascii forma
I am attaching herewith a excel sheet in which I am supposed to validat
and extract data from the green coloured cells. The data is to be i ASCII format i.e fixed length fields after proper validations. Ther has to be no separators and the spaces in any field has to be there i the file structure as it is. I think this should be possible using VBA or macro can someone help o this and is some module addins available to do this task . pramo Attachment filename: excel-form.xls Download attachment: http://www.excelforum.com/attachment.php?postid=46229 -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to ASCII Fixed Format | Excel Discussion (Misc queries) | |||
parsing data with no set delimiter or fixed length. | Excel Discussion (Misc queries) | |||
Create an ASCII Fixed Length File from Excel | Excel Discussion (Misc queries) | |||
how do I export a worksheet as a fixed format ascii file | Excel Discussion (Misc queries) | |||
2 Qs: grab net page, and import as fixed length format | Excel Programming |