Re: Print multiple xls-files from Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you for your input.

It might be to much for the printer to handle if you do this with to may
files.
I guess you could divide them and do it in smaller batches.
But its is still one more problem.
Since it also includes on or more sheets, this does not do the job, since it
only prints the active *** when printing this way.

Any other suggestions?

"Jeanette Cunningham" skrev:

Noob,
if I am remembering correctly, you can open windows explorer and select
several files, right click them and select print.
All the selected files will print, one by one.


Jeanette Cunningham -- Melbourne Victoria Australia


"Noob" <Noob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E765E152-2EF7-40E8-B12D-B30E92A10476@xxxxxxxxxxxxxxxx
Hi.

I have a user (my boss) who has about 500 excel files (excel 2003) in a
folder.
Each file contains one or more sheets.

Now it is needed to print all of these files on paper on the default
printer.
Since it is also several files among them who has more than one ***, I
guess it will be way over 1000 papers.
For me it seems like a waste, but who am I to decide!

Is there any way to do this from Access or maybe Excel?
I have never really done any programming in Excel, so I am not used to the
environment there.
In Access I have more experience.

I have searched for it and has found only one that covers the topic.
But I can not really adjust it to fit my need.
And of course my boss wants this done yesterday.

Is there a way to loop through the folder and open each file, print it,
move
to next *** if any and print that as well.
After all sheets are printed, close the file and open the next one and do
the same thing.
Then repeat until all the files in the folder has been printed.

From what I understand, there might be a problem with sending to much
information to the printer.
I saw in a previous post, that this was solved by waiting for the printer
to
finish printing before sending the next job.
Since we know that there will only be one page per ***, maybe this can
be
solved by adding a short pause between the jobs.
The printers are quite big, so it will work alot faster than a local
printer
would.

It is a one time only-thing, so any ugly solution will do.
Otherwise my boss will have to spend a looooong time manually opening and
printing all these files.

Is there anyone out there who can help me with this or should I tell my
boss
that it can not be done?

Thanks in advance.



.

Quantcast