ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   printing/importing problems (https://www.excelbanter.com/excel-programming/296582-printing-importing-problems.html)

steve

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?



AAA2e72

printing/importing problems
 


steve

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.
.


Tom Ogilvy

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.




All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com