View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BEEJAY BEEJAY is offline
external usenet poster
 
Posts: 247
Default Convert Workbook (to text)

Greetings:
Have workbooks with 6 - 8 worksheets.
Need to convert all "used" cells to text
ie: no formulas, or vba left over
(like RDB does with his SendMail add-in)
After this is done, i will have to do all kinds of hiding, deletions,
etc. but the convert have to be done first, so I don't loose info due
to the deletions.
The end result will be in a format that is e-mailed in .xls format
and will look the same as the actually hard copy.
thanks