Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default printing/importing problems


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 141
Default printing/importing problems

Ya I have been looking for the pages individually but
that gets very irritating and old day after day. If it
was the same page every time then it would be easy. Or if
the format was in table format then importing it into
excel would not mess it up to bad

Not sure what u mean by "demarcated'? That is, if you
have a *.TXT file, pagination information"

Maybe this will answer your q...

Each page is formatted different, some pages are in
paragraphs, some pages sum up data, athers are in tables.


-----Original Message-----
If you have a text file, how are the 'pages'

demarcated'? That is, if you have a *.TXT file,
pagination information is not held within the file itself.

In contrast, dynamic (changes with font sizes, margins

etc) are held within a word document. AND, WORD allows
you to print selective pages.

So, you could import your text file into Word and print

just the pages you want: the trick is to identify the
page numbers-you can do this visually.
.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default printing/importing problems

Hey Slick,
You publicly claimed my code doesn't work. I can't reproduce that - it
works fine for me. How about returning to that thread and responding
exactly how it doesn't work.

--
Regards,
Tom Ogilvy

"AA2e72E" wrote in message
...
If you have a text file, how are the 'pages' demarcated'? That is, if you

have a *.TXT file, pagination information is not held within the file
itself.

In contrast, dynamic (changes with font sizes, margins etc) are held

within a word document. AND, WORD allows you to print selective pages.

So, you could import your text file into Word and print just the pages you

want: the trick is to identify the page numbers-you can do this visually.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing List from Excel to Word printing labels spacing problems blakepm Excel Discussion (Misc queries) 1 January 21st 10 03:52 PM
Importing into excel PROBLEMS [email protected] Excel Worksheet Functions 1 January 11th 08 03:01 PM
Importing problems remondrop Excel Discussion (Misc queries) 3 May 25th 07 08:16 PM
problems with importing an image Todd Excel Discussion (Misc queries) 0 January 29th 07 10:10 PM
Problems Importing from Access davey Excel Discussion (Misc queries) 1 July 8th 05 05:47 PM


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"