View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 20
Default printing/importing problems

I have a large text file, 100+ pages. Out of this text
file I need 5 pages. The order of the pages are different
every time (one day I may need pages 14, 20, 30,31,32.
The next day I may need 6, 50, 63, 74, 75). In the past
my company has printed the whole document, sorted through
the pages, kept what they wanted and discarded the rest.

This process of printing all of it takes too long not to
mention the waste of the paper. I have tried importing it
into excel and using VBA to delete what I did not want.
but Im having trouble getting the formatting to look good
for the final printed pages.

I was wondering if using VBA I could open the document in
word pad and do a search for the pages I wanted then
print just those pages?

Or dose any one have any other ideas?