Friday, September 23, 2011

How to add the Print Directory feature for folders in Windows XP, in Windows Vista, in Windows 7

Source: http://support.microsoft.com/kb/321379

Windows Vista or Windows 7

Step 1: Create the Printdir.bat file

To do this, follow these steps:
  1. Click Start, click Run, type notepad, and then click OK.
  2. Paste the following text into Notepad:
    @echo off
    dir %1 /-p /o:gn > "%temp%\Listing"
    start /w notepad /p "%temp%\Listing"
    del "%temp%\Listing"
    exit
  3. On the File menu, click Exit, and then click Yes to save the changes.
  4. In the Save As dialog box, type the following text in the File name box, and then click Save:
    %windir%\Printdir.bat

    Note If you receive a dialog box that says you don't have permission to save in this location, you can save the file to the desktop. Next, you click Start, click Run, type %windir%, and then click OK. Then, you can copy the file from the desktop to the location.

Step 2: Edit the registry

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
  1. Click Start, click Run, type Notepad, and then click OK.
  2. Type the following commands in Notepad.
    Windows Registry Editor Version 5.00

    [HKEY_CLASSES_ROOT\Directory\Shell]
    @="none"

    [HKEY_CLASSES_ROOT\Directory\Shell\Print_Directory_Listing]
    @="Print Directory Listing"

    [HKEY_CLASSES_ROOT\Directory\shell\Print_Directory_Listing\command]
    @="Printdir.bat \"%1\""

    [HKEY_CLASSES_ROOT\SOFTWARE\Classes\Directory]
    "BrowserFlags"=dword:00000008

    [HKEY_CLASSES_ROOT\SOFTWARE\Classes\Directory\shell\Print_Directory_Listing]
    @="Print Directory Listing"

    [HKEY_CLASSES_ROOT\SOFTWARE\Classes\Directory\shell\Print_Directory_Listing\command]
    @="Printdir.bat \"%1\""

    [HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}]
    @=""

    [HKEY_CLASSES_ROOT\SOFTWARE\Classes\Directory]
    "EditFlags"="000001d2"
    On the File menu, click Save As.
  3. In the Save in list, click Desktop.
  4. In the File name box, type PrintDirectoryListing.reg, click All Files in the Save as type list, and then click Save.
  5. On the desktop, double-click the PrintDirectoryListing.reg file to add the registry keys to the Windows registry.
  6. Click OK in the message box.

Tuesday, June 7, 2011

Date format that includes day of week

You will need to use a custom formula. Go to Format-Cells, and select Custom. Type in:

dddd, mm/dd/yyyy

Source: http://www.mrexcel.com/archive/Dates/7591.html

Password Protect Microsoft Office 2003 Documents

1. Open the Document you wish to encrypt / password protect

2. Click Tools, then Click Options

3. Click Security tab, and then Click Advanced button

4. Scroll down and Click RC4, Microsoft Enhanced RSA and AES Cryptographic Provider. By default the Key Length is 128 and the box Encrypt document properties is checked. Verify this and Click OK

Source: http://www.groovypost.com/howto/microsoft/office/password-protect-microsoft-office-2003-documents/

Wednesday, May 18, 2011

Excel 2003 Zebra Colored Rows

In MS Excel 2003

1. Select the entire table.
2. Goto Format – Conditional formatting
3. Select ‘Formula Is’ ption in 1st Dropdown
4. Enter Formula =Mod(Row(),2)=0
5. Select the color you want to fill every alternate row and click ok

Source: http://msexcelraj.wordpress.com/2007/11/11/excel-format-table-with-zebra-stripes/

Thursday, April 7, 2011

Tortoise SVN Moving files and folders

If you want to do a simple in-place rename of a file or folder, use Context MenuRename... Enter the new name for the item and you're done.

If you want to move files around inside your working copy, perhaps to a different sub-folder, use the right-mouse drag-and-drop handler:

  1. select the files or directories you want to move

  2. right-drag them to the new location inside the working copy

  3. release the right mouse button

  4. in the popup menu select Context MenuSVN Move versioned files here


http://tortoisesvn.net/docs/release/TortoiseSVN_en/tsvn-dug-rename.html

Friday, March 18, 2011

How to Convert ALL CAPS to Lowercase Letters

I will assume you are using Microsoft Word. I am not sure if this works in other word processing programs or not. Highlight the all caps text you would like to convert to lowercase letters. Next, simply press Shift+F3.

Source: http://www.associatedcontent.com/article/65773/how_to_convert_all_caps_to_lowercase.html