Print multiple xls-files from Access

  • Thread starter Thread starter Noob
  • Start date Start date
N

Noob

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 sheet, 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 sheet 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 sheet, 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.
 
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
 
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 sheet when printing this way.

Any other suggestions?

"Jeanette Cunningham" skrev:
 
http://www.print-conductor.com
I found this program, that seems to do the job.
Free to use. ;)

I havent tried more than a handful of files, but it works so far.
Now my boss has to test it for all files.

I can also infor, that it works for other file types as well, but I havent
tried it yet.
But maybe someone else has use of this.

"Noob" skrev:
 
Back
Top