• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

Scheduling prints to the network printer


I want to schedule printing of a certain excel document at a certain time of the week. There is an added complexity here. The excel document name is not the same every week.

The folder in which the excel document resides is always the same. lets say, W:\Documents\Template\*.

The excel document is having the name format, "Weekly Status Report - <<date>>". As you can see, the date in the name of the document keeps changing once every week.  So, for scheduling, I want to go to the folder and select the document having the first name as "Weekly Status Report" and automate the printing at 7AM on every Wednesday. (There are other excel documents in the folder, but none starts with "weekly status report" first name, so we are fine to say that there will always be only one document with "Weekly Status report" first name in the folder).

I have windows 2000 and the network printer is connected to lpt1: and is the default printer too.

Can anyone provide solution for this.


  • 3
1 Solution
Hmmm check if this software would work with you..

This is the closest thing I could find for your problem.. You also could program it using VB, or whatever other language you know..  but this is not really my domain, I dable a bit in programmation, but not much.
another software to automate task using scripts would be:


there is an integrated script language in there that you could use to find the file you absolutly need to print..
kamurAuthor Commented:
Thanks Yan for all the links...I had gone thru all of them, it seems to be doing what I wanted. But I dont want to spend any money for this..will keep looking if I can write something up on my own or put a simpler process without any third party software.

Thanks anyway,

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now