Tips & Tricks - MemoSoup

Outlook 2007: set default font in Outlook

I think, the “Options” window in Outlook is one of the most tangled things in IT. The programmers were so smart to create real “spaghetti” window! Did they ever hear about “user friendly” interfaces? They could at least add the “Search” field somewhere – otherwise, it’s not possible to find anything.

Here is the way [...]

Oracle: checksum function for strings

CREATE OR REPLACE FUNCTION get_checksum(source_string IN VARCHAR) RETURN VARCHAR IS raw_string RAW(2048); result RAW(2048); BEGIN raw_string := utl_i18n.string_to_raw(source_string); result := sys.dbms_crypto.hash(raw_string, sys.dbms_crypto.hash_sh1); RETURN result ; END; /

MS Word: put syntax highlighed code into the document

Here is the simple method to put the code with highlighting into the Word document:

Download and install Notepad++. This is easy-to-use and yet very powerful text editor with a lot of features, support of the plugins etc. Put your code into the Notepad++ edit window

Configure the language, if Notepad++ did not do [...]

Windows: local printer option is greyed out

Some time ago I need to add the local printer to the system, however, this option was greyed out in the “Add printer” wizard. The problem was caused by local policy, preventing the adding of the new devices to the system.

The following should be done to enable “Add local printer” option

Start the policy [...]

PDF file: set the bookmark

Strange enough, Adobe Acrobar Reader does not allow to put the user-defined bookmarks into the PDF file (and this is so simple and necessary thing!)

However, with the help of some “hack” the bookmarks still could be used.

Here is the trick:

Go to PDF Hacks site and download the zip file with the javascript. [...]

AppleScript: rotate mov file in QuickTime Pro

Some kind of life hack: it’s very easy to make mov file with digital camera, rotating it 90 degrees. However, it’s not so easy to convert the result file to the ‘visible’ form.

QuickTime Pro(the native product from Apple) could do this, and I found the AppleScript script, which could make it even more easy.

[...]

Office: check if PowerPoint is running

Dim objAPP, sMsg On Error Resume Next Set objAPP = GetObject(, "PowerPoint.Application") If TypeName(objAPP) = "Empty" Then sMsg = "not started" Else sMsg = "started" End If MsgBox "PowerPoint is " & sMsg, vbInformation, "PowerPoint" if sMsg = "started" then objAPP.Visible = true

MS Word: replace spaces to non-breaking

To insert it manually, use Ctrl+Shift+Space

Selection.HomeKey Unit:=wdStory Selection.Find.ClearFormatting Selection.Find.Style = ActiveDocument.Styles("Normal") Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = " " .Replacement.Text = "^s" .Forward = True .Wrap = wdFindContinue .Format = True End With Selection.Find.Execute Replace:=wdReplaceAll

Check the default browser

The following section in registry should be checked:

HKEY_CLASSES_ROOT\http\shell\open\command Key: (default)

Most (but not all) browsers check it to determine the current browser.

currentBrowser = RegistryGet("HKEY_CLASSES_ROOT","http\shell\open\command","") MsgBox( currentBrowser )

Some browsers could create additional section HKEY_CLASSES_ROOT\http\shell\OpenWith\command, which helps to avoid the conflict with IE settings.

WHICH command for DOS

If You need the analog of Unix ‘which’ command and do not have Resource Kit, the following batch file will help. The code was found on www.ss64.com Published with the permission of the author, Clay Calvert.

@echo off SETLOCAL (set WF=) :: Look for file in the current directory for %%a in ("" %!!%) do [...]

Meta

Tags