printing from folder

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




On Thu, 19 Jan 2006 21:53:00 +0100, "sali" <gabor.salai@tel.net.ba> wrote:

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

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" <gorddibbATshawDOTca> wrote in message
news:3k20t15i1ao2o9n8gj6f80hka2bto6t8h7@4ax.com...
> 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...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
>
>
>
>
> On Thu, 19 Jan 2006 21:53:00 +0100, "sali" <gabor.salai@tel.net.ba> wrote:
>
> >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
> >
>
> Gord Dibben MS Excel MVP

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

On Thu, 19 Jan 2006 23:59:50 +0100, "sali" <gabor.salai@tel.net.ba> wrote:

>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" <gorddibbATshawDOTca> wrote in message
>news:3k20t15i1ao2o9n8gj6f80hka2bto6t8h7@4ax.com...
>> 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...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
>>
>>
>>
>>
>> On Thu, 19 Jan 2006 21:53:00 +0100, "sali" <gabor.salai@tel.net.ba> wrote:
>>
>> >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
>> >
>>
>> Gord Dibben MS Excel MVP
>

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


"sali" <gabor.salai@tel.net.ba> wrote in message
news:uRANSpTHGHA.3856@TK2MSFTNGP12.phx.gbl...
> 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
>
>

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" <croberts@tampabay.rr.com> wrote in message
news:edCvfkVHGHA.984@tk2msftngp13.phx.gbl...
> 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" <gabor.salai@tel.net.ba> wrote in message
> news:uRANSpTHGHA.3856@TK2MSFTNGP12.phx.gbl...
>> 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
>>
>>
>
>