View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Frank Kabel" wrote...
not supported as build-in function. Why not create a PDF file?

....
"Ramana Murthy" schrieb im Newsbeitrag
Is it possible to create a formatted text file from Excel work book?

By stating "formatted", I mean that the output file should be having a
pagewise report header, column headings etc. Like those reports which we
generate using COBOL, Dbase etc.


It *is* provided by a built-in facility. File Page Setup allows the user
to specify multiple line headers and footers (Header/Footer tab in Page
Setup dialog). Print titles allow for column headings (Sheet tab in Page
Setup dialog). Whether it's a good idea to use Excel or any other
spreadsheet to generate such reports is another matter entirely.