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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to extract data in .txt format from the excel sheet in a fixed length ascii forma
Hi
looking at your spreadsheet I still don't know what you're trying to extract. You may describe your issue in plain text (as most people won't open attachments) and give some example data rows (also plain text please) -- Regards Frank Kabel Frankfurt, Germany "pramod_kmr " schrieb im Newsbeitrag ... I am attaching herewith a excel sheet in which I am supposed to validate and extract data from the green coloured cells. The data is to be in ASCII format i.e fixed length fields after proper validations. There has to be no separators and the spaces in any field has to be there in the file structure as it is. I think this should be possible using VBA or macro can someone help on this and is some module addins available to do this task . pramod Attachment filename: excel-form.xls Download attachment: http://www.excelforum.com/attachment.php?postid=462294 --- Message posted from http://www.ExcelForum.com/ |
Reply |
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 |