Spy Journal 3.0 Filtering the web for you

Security vulnerabilities were announced today in Microsoft Excel and also in Drupal.

See the Official MS security advisory (968272), and the explanation by ars technica.

Our advice for now would be to be EXTREMELY careful when opening any Excel spreadsheet, Word document or PowerPoint file that is emailed to you. Rule of thumb – if you don’t know the person who set you a file (any file) NEVER open it. If you weren’t expecting the file from someone you do know then email or call them and ask them if they sent you it and if so what it is BEFORE opening it. I trust that MS will release the appropriate patch shortly.

The Drupal security vulnerabilities have been announced on the Drupal website and upgrades and patches released for both version 5 and 6.

For our Jethro Consultants Web hosting customers this means an immediate patch for those who are on maintenance contracts with us, and for those who are not they pay us by the hour to apply. We get to those as soon as we can. We are also busy upgrading our own websites.

I had a colleague ask me this question today. (edited to protect the innocent – you know who you are!)

I copy data out of E_____ (am sure you have heard of it), and paste it into an excel spreadsheet.  I have a couple of pivot tables hanging off the back of this data.  As this is project data, the longer the project goes on, the larger the dataset gets.  Is there any way in VBA that I can get the pivot table to auto-expand the data set that it is using? 

Here is my answer.

Hey W__

There is a simple solution that doesn’t require any vba at all

First you will need to make a dynamic range name that covers the data being pasted.

I just had to go rescue a snake from a friends aviary. It had helped itself to a bunch of birds and was lying there quite sleepy until i disturbed it with my snake hook. After I picked it up by the tail it got quite aggressive and was able to climb up its body using the very fat bump in the middle and was going to strike me so I  promptly dropped it. I then got it into the bag and took it off to a wooded area to release it so it could go lie up an enjoy its stolen fruits – er birds. 1 budgie and several finches.

This photo I took as I released it shows the very large lump in its guts!

Music tracks only listed here. Screenshots taken from Media Player with Microsoft OneNote and pasted into Windows Live Writer and then published to a Drupal 6 website.