Probably simple...

MajorMaccas · 13 Jun 2012 at 14:50

Just trying to streamline my workflow, I need 2 things to happen on log on daily:

1) Print a copy of the Trunking VLU Weights sheet - literally just the right click -> print from the context menu in the explorer window. If this can happen on log on somehow that would be ideal.

2) Save a copy of the Daily Trunk Summary in another folder suffixed with the day.month. Currently I open this spreadsheet, save as, go into the archive folder, put yesterday's day.month (12.6) after the filename and save, then open the "live" version again.

Is it possible to script these two processes and have both occur on log on? Thanks

MajorMaccas · 14 Jun 2012 at 11:23

Windows

MajorMaccas · 15 Jun 2012 at 11:14

It's my workstation on my work network, so I'm not sure what sort of limitations there are re: scripts, security seems pretty lax to be fair. They're running XP. Thanks!

MajorMaccas · 15 Jun 2012 at 11:51

I forgot to mention, the trunking weights sheet is .xls, does this make a difference to the PRINT command? Also the printer is a network printer, so the port is IP_10.137.4.31 not a standard LPT1. Thanks for your help so far, that network file copy page looks very helpful too

MajorMaccas · 15 Jun 2012 at 12:07

I've found a handy tool called classExec, which allows a batch to use DDE commands - so anything with a "print" command on a context menu.

Edit: Sorted 1), now onto the more complicated saving a copy of the daily trunk summary!

MajorMaccas · 15 Jun 2012 at 12:40

The problem with this is the complicated nature of where it's saved; monthly folders, although this is easily fixed by editing the batch on the last day of every month to use the following month's folder - or make a second batch to edit the first and run that on the first of every month!

Also I only run this week days, so when I come in Monday, I'll want it to save it with friday's date. I don't mind editing the batch file at the end of every month, just need the weekly cycle to be automated.