Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Scheduling prints to the network printer

Posted on 2004-08-25
4
Medium Priority
?
169 Views
Last Modified: 2010-04-13
Hello,

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.

Thanks


0
Comment
Question by:kamur
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 15

Expert Comment

by:Yan_west
ID: 11894029
Hmmm check if this software would work with you..

http://www.traction-software.co.uk/batchprint/addons/excel.html
0
 
LVL 15

Expert Comment

by:Yan_west
ID: 11894086
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.
0
 
LVL 15

Accepted Solution

by:
Yan_west earned 1000 total points
ID: 11894128
another software to automate task using scripts would be:

http://www.wintask.com/product.htm

there is an integrated script language in there that you could use to find the file you absolutly need to print..
0
 

Author Comment

by:kamur
ID: 11932917
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,

0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
As much as Microsoft wants to kill off PST file support, just as they tried to do with public folders, there are still times when it is useful or downright necessary to export Exchange mailboxes to PST files. Thankfully, it is still possible to e…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question