View RSS Feed

Recent Blogs Posts

  1. Setting Printers through Group Policy...an encore... (and the death of Scripts)

    by , 21st November 2012 at 10:25 PM
    Well, I know its been a long time since my last published blog post! The truth is Ive been working on a few for a while now - but just never got round to finishing any of them.

    Heres the first of my next batch... a return to an earlier thread of posts, originally related to Printing on Remote Desktop.

    First, a bit of background... traditionally, most systems will be set up to map printers via a logon script. The script typically checks a machine name and adds the appropriate ...
    Categories
    Software
  2. Excel 2010 - Printer Fails to Communicate

    by , 5th May 2011 at 02:52 PM (It looks like you are trying to write a blog...)
    Long term users of Excel VBA will be familiar with slow processing of page set up if code like the following is used:

    With ActiveWorksheet.PageSetup
    .CenterHeader = "Title of the Worksheet"
    .LeftFooter = "Today's Date"
    .RightFooter = "Page &P of &N"
    .PrintArea = "$A$1:$H$28"
    End With


    The problem with the code is that, despite the use of the With statement, each line requires a call to the printer driver, rather than the whole statement ...

    Updated 19th October 2011 at 12:30 PM by Pico

    Categories
    Office Agonistes