View RSS Feed

It looks like you are trying to write a blog...

I am the data analyst for an independent school. I am mainly concerned with managing and analysing the data held in our MIS (currently CMIS). In my academic tracking work I make extensive use of the CEM baseline data (MidYIS, Yellis and Alis) .

I anticipate that much of this blog will be centred around my use of Microsoft Office and VBA. Since I am in the process of considering a complete re-write of my code and approach, I might even use this blog as a dumping ground for my thoughts on the process.

  1. Pico's Avatar

    Some Text Editors I Have Known

    by
    Pico
    , 24th February 2012 at 03:01 PM (It looks like you are trying to write a blog...)
    This blog has been sorely neglected since I got caught up with our school's switch between MIS providers. So, in an effort to rescue it from the hordes of one-post blogs on the web, here, for no good reason at all, are some of the text editors I have known:

    Notepad

    Yes, we all have to start somewhere…

    Wordpad

    Has a better time with Linux/Unix new line breaks than Notepad, but it's a rich text editor >_<

    Pico
    ...
    Categories
    Favourite Things
    Comments 3 Comments
    Read MoreRead More
  2. Pico's Avatar

    Excel 2010 - Printer Fails to Communicate

    by
    Pico
    , 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 ...

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

    Categories
    Office Agonistes
    Comments 3 Comments
    Read MoreRead More