printing from folder

  • Thread starter Thread starter sali
  • Start date Start date
S

sali

have a lot of excel docs [all workbooks single sheet/single page], and want
to print all of them from win explorer's window [folder list] by selecting
[select all] and right click and select print. there are few hundreds of
docs.

it works, but!
some of docs are dropped, not printed, about 10% of them, and print order of
rest of them doesn't confirm to any order in folder [nor name sort nor date
sort]

my solution was to create vbscript, to use files collection and apply
printout method to all of them.

is there some easier method [this requires me to write vbscript, not heavy
work, but anyway requires attention]

thnx
 
sali

Several methods to accomplish this.......I like Tushar's best.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR >MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-ins>Directory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP




have a lot of excel docs [all workbooks single sheet/single page], and want
to print all of them from win explorer's window [folder list] by selecting
[select all] and right click and select print. there are few hundreds of
docs.

it works, but!
some of docs are dropped, not printed, about 10% of them, and print order of
rest of them doesn't confirm to any order in folder [nor name sort nor date
sort]

my solution was to create vbscript, to use files collection and apply
printout method to all of them.

is there some easier method [this requires me to write vbscript, not heavy
work, but anyway requires attention]

thnx
Click to expand...

Gord Dibben MS Excel MVP
 
sorry to be unclear, i am affraid.

i needed help on printing *excel document* content [docs inside selected
folder], not folder [directory list] content.

as i explained, selecting files and right click brings pop-up menu with
"print" item, but in my case, that print dropps some files not to be
printed.

any idea why?

to be sure of job, i constructed vbscript to open and print each doc, but
wander may it be done with some simple windows tool/option?



Gord Dibben said:
sali

Several methods to accomplish this.......I like Tushar's best.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR >MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-ins>Directory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP




have a lot of excel docs [all workbooks single sheet/single page], and want
to print all of them from win explorer's window [folder list] by selecting
[select all] and right click and select print. there are few hundreds of
docs.

it works, but!
some of docs are dropped, not printed, about 10% of them, and print order of
rest of them doesn't confirm to any order in folder [nor name sort nor date
sort]

my solution was to create vbscript, to use files collection and apply
printout method to all of them.

is there some easier method [this requires me to write vbscript, not heavy
work, but anyway requires attention]

thnx
Click to expand...

Gord Dibben MS Excel MVP
Click to expand...
 
sali

You were not unclear, I just misread your original post.

As to your real problem, I have never attempted to print more than one file at a
time so not competent to assist.

Gord

sorry to be unclear, i am affraid.

i needed help on printing *excel document* content [docs inside selected
folder], not folder [directory list] content.

as i explained, selecting files and right click brings pop-up menu with
"print" item, but in my case, that print dropps some files not to be
printed.

any idea why?

to be sure of job, i constructed vbscript to open and print each doc, but
wander may it be done with some simple windows tool/option?



Gord Dibben said:
sali

Several methods to accomplish this.......I like Tushar's best.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR >MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-ins>Directory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP




have a lot of excel docs [all workbooks single sheet/single page], and want
to print all of them from win explorer's window [folder list] by selecting
[select all] and right click and select print. there are few hundreds of
docs.

it works, but!
some of docs are dropped, not printed, about 10% of them, and print order of
rest of them doesn't confirm to any order in folder [nor name sort nor date
sort]

my solution was to create vbscript, to use files collection and apply
printout method to all of them.

is there some easier method [this requires me to write vbscript, not heavy
work, but anyway requires attention]

thnx
Click to expand...

Gord Dibben MS Excel MVP
Click to expand...
Click to expand...

Gord Dibben MS Excel MVP
 
My recommendation is to open a Master workbook and write code in it to open
each of the other workbooks in turn and print them out, then close
them.......could be even at that time you could insert a Project Number in
each file, or DateCode, or something to identify this particular printout
with the associated files.......

Vaya con Dios,
Chuck, CABGx3
 
thankx, it is valid solution, but i wanderd to have solution on windows gui
level, not at aplication level.

any experioence which method/api is called when used print option from
pop-up method in folder list?


CLR said:
My recommendation is to open a Master workbook and write code in it to
open
each of the other workbooks in turn and print them out, then close
them.......could be even at that time you could insert a Project Number in
each file, or DateCode, or something to identify this particular printout
with the associated files.......

Vaya con Dios,
Chuck, CABGx3


sali said:
have a lot of excel docs [all workbooks single sheet/single page], and want
to print all of them from win explorer's window [folder list] by
selecting
[select all] and right click and select print. there are few hundreds of
docs.

it works, but!
some of docs are dropped, not printed, about 10% of them, and print order of
rest of them doesn't confirm to any order in folder [nor name sort nor date
sort]

my solution was to create vbscript, to use files collection and apply
printout method to all of them.

is there some easier method [this requires me to write vbscript, not
heavy
work, but anyway requires attention]

thnx
Click to expand...
Click to expand...
 
Back
Top