As an addendum to the post that I just wrote about adding a slideshow to your website, I would like to add some more information about adding a Picasa slideshow to a site that is hosted on http://www.wordpress.com. It is not possible to embed Picasa slideshows into websites that are...
Continue reading...Tech Support
Add a Slideshow to a Website
One of my friends asked me how to add a slideshow like the one above to a website. Here is what I told her. 1. Get a gmail account (http://www.gmail.com) if you don’t already have one. If you think that you will do this often for the particular website, make...
Continue reading...Simple Macro to Delete Two Blank Worksheets and Move One Worksheet to Another (Master) File
Here is a macro that will delete Sheet 2 and Sheet 3 from one file and then move the remaining worksheet from that file into another file called master.xls. Hope someone finds this useful one day. Sub deletemove() ‘ deletemove Macro ‘ Keyboard Shortcut: Ctrl+l Sheets(“Sheet2”).Select ActiveWindow.SelectedSheets.Delete Sheets(“Sheet3”).Select ActiveWindow.SelectedSheets.Delete ActiveSheet.Select...
Continue reading...Simple Macro to Move a Worksheet to Another (Master) File
Today’s problem: I had a large collection of Excel worksheets (around 200 or so) that were all in separate files and I wanted to merge them all together into one master file. (To be clear, I needed the resulting file to contain all of the 200 worksheets in order —...
Continue reading...Vista Control Panel Disappears and Can't Print
One of my colleagues had a very strange problem with her computer (Dell Optiplex 755 running Windows Vista). First of all, she found that she couldn’t print anything this morning, despite being able to print in the past. So, she called me over to see if I could figure out...
Continue reading...Keeping a Record of Changes when Copying and Pasting
The “track changes” function of Microsoft Word is a very useful tool for editors and people who work on documents in teams. With it you can keep a record of who made what changes and when they were made. If only one person is working on a particular document at...
Continue reading...Hide the Ribbon in MS Office 2007 Products
As I mentioned earlier, I have recently started using Office 2007. So far, it hasn’t wowed me, but I don’t really have complex needs in the word processing department, so I guess I haven’t really fully tested its abilities. The main thing that I need a word processor to be...
Continue reading...Convert VOB to MPG without Software
Videos that are stored on DVDs are often in VOB format. If you want to be able to store the VOB file on your computer as a more versatile MPG file (in mpeg format), just copy the file to your hard disk and change the extension of the file from...
Continue reading...Hide Paragraph Marks in Outlook 2007
Another strange thing happened when I upgraded from MS Office 2003 to 2007. When I compose an email, paragraph marks show up all over the page. I find them very distracting and not particularly useful. (I used to use them back when WordPerfect was the dominant word processor, but that...
Continue reading...Simulating Autocomplete in MS Office 2007
I upgraded from Microsoft Office 2003 to 2007 at my office today and the first thing I noticed was that the autocomplete function is missing from Word 2007. This is rather annoying because there are certain phrases (like the name of my company and other organizations that we often work...
Continue reading...