Reduce PDF Size

When saving a Word file as PDF there is a quick trick to reduce the resulting file size. 

Use the following procedure.

1. In Word, use the normal Save as -> PDF
2. Open the PDF that was created (if it does not open automatically)
3. Select File -> Save as
4. Click "Save".

This overwrites the current PDF file with a new version that removes the extra baggage that Word added.

As an example, I had a file that was originally 8,594 KB. After using the above procedure it was reduced to 6,353 KB.

Setup:

• Word 2010
• Adobe Acrobat 9
• Windows 7

Excel: Removing Blank Rows

Excel has a powerful filtering capability that lets you view, among other options, the data without blank rows. But how do you remove the blank rows from your data? The following VBA code does the following:

1. Select a cell in the maximum row
2. Check if the selection is blank
3. Delete if blank
4. Move up 1 cell

      Dim x As Integer
      ' Set numrows = number of rows of data.
      NumRows = 1400 -2
      ' Select max cell
      Range("B1400").Select
      ' Establish "For" loop to loop "numrows" number of times.
      For x = 1 To NumRows
         ' Insert your code here.
         If Selection.Text = "" Then
            Selection.EntireRow.Delete
         End If
         ' Selects cell down 1 row from active cell.
         ActiveCell.Offset(-1, 0).Select

There is probably a smarter way to select the maximum number of rows, but for my data it was fixed.

Bathroom Documentation Confusion

I went out to lunch the other day and the restaurant had a confusin sign on the door to the bathrooms:

Sometimes there is just nothing to say. I mean, what is this?

Am I only allowed in the bathroom if I am a peeping Tom? Are the women here so beautiful that I would climb over a wall to see them? Or are they so ugly that I would climb over a wall to get away?

Check that Font

There is a website that lets you see your own custom text in every font that is on your computer. Just go to this website:

http://www.wordmark.it/

[Source Cybertext]

AIT: Book Properties in Word

I can never find the link in the AIT knowledge base to the list of the book properties along with the corresponding Word document properties. Here they are:

• the Title property stores the information in the Title field
• the Super title property stores the information in the Subject field
• the Version property stores the information in the Keywords field, and
• the By line property stores the information in the Author field. 

[source AIT KC]