View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pramod_kmr pramod_kmr is offline
external usenet poster
 
Posts: 1
Default 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