Microsoft Windows

Need a YouTube Desktop Uploader for Windows? Try This!

150 150 rhecht

Having in some instances very large video files to upload to YouTube, I was looking for a desktop tool to upload YouTube videos. Google Video once had a nice, simple tool, as did YouTube once a very long time ago. Since then those tools were deprecated and we were forced to upload large videos through a browser, leading to lags.

Well, there is a neat 3rd party tool that does the job for you nicely. It’s called “Free Studio” and, well, it’s free.

Free Studio not only does a great job uploading YouTube videos, it also does various other multimedia services. Among other things, you can easily:

– convert video and audio files between different formats as well as iPod, PSP, iPhone, BlackBerry and all other popular mobile phones and devices;
– burn and rip DVDs and audio CDs;
– upload and download YouTube videos and music to your computer, iPod, PSP, iPhone or BlackBerry;
– perform basic editing of audio and video files;
– record videos and make snapshots;
– create 3D videos and images.

The requirements are as follows: Windows XP SP3, Vista, Windows 7 and .Net Framework 2 SP2

According to their site, “Free Studio does not contain spyware or adware. It’s absolutely free and completely safe to install and run.” So far I’ve had no issues!

Microsoft Outlook Freezes and or Crashes When Opening Attachments

150 150 rhecht

Let’s say you’re running Outlook 2007, are connected to a web server via POP, and it freezes/crashes when opening attachments. A solution to that problem would be to locate the “scanpst” utility, usually found here:

Outlook 2010: C:Program FilesMicrosoft OfficeOffice14scanpst.exe

Outlook 2007: C:Program FilesMicrosoft OfficeOffice12scanpst.exe

Outlook 2003: C:Program FilesCommon FilesSystemMSMAPI<locale ID>scanpst.exe

Outlook 2002/XP: C:Program FilesCommon FilesSystemMAPI<locale ID>scanpst.exe

Outlook 2000: C:Program FilesCommon FilesSystemMAPINTscanpst.exe

Outlook 97 / Outlook 98: C:Program FilesCommon FilesWindows Messagingscanpst.exe

This will further require you to find the Outlook PST data file that contains your emails. Navigate to that folder, usually through these paths:

C:­Documents and Settings­Some UserApplication Data­Microsoft­Outlook­outlook.pst

or

C:UsersSome User­Application Data­Microsoft­Outlook­outlook.pst

Next, run the scan, and it should fix any outlook corruption issues.

Removing All Hyperlinks in Excel

150 150 rhecht

Removing a bunch of hyperlinks can be tedious. Imagine the time you have to spend right-clicking on each of those links and selecting ‘remove hyperlink’ on the context menu. Of course it would just take two clicks, but what if you are to remove a hundred of them or perhaps 1000 hyperlinks? I’m sure that would be enough to scrape out the paint of your right-mouse button.

Below are some simple techniques you can use in order to remove single to multiple hyperlinks on a page:

Removing just one hyperlink

1. Right-Click on the cell and select Remove Hyperlink from the context menu.

Removing hyperlinks using the cell format

1. Select the cells having hyperlinks. You can use CTRL+LEFT CLICK to randomly select a cell.

2. On the menu click on Edit. Hover your mouse to the option Clear and select Fomats. Please note that the cell is still clickable to remove the hyperlink completely you have to select Clear->All.

Remove Excel hyperlinks on selected cells the better way

1. Type in any text or number in a blank cell

2. Right-click and select Copy on the context menu.

3. While pressing CTRL, select each cell with the hyperlink you wish to be removed

4. On the Edit menu, select Paste Special.

5. Under Operation, click Multiply and then click OK.

6. If you are using Office 2007, you may need to click or change the cell format to Normal found at the Styles Group Toolbar.

Removing Excel hyperlinks using a macro

Assuming you know excel programming you could create a macro to automatically remove the hyperlinks.

1. Start Visual Basic Editor. Alternatively you can press ALT-F11 to start the editor.

2. Double click the workbook you are using on the Project Explorer.

3. Type the following text:

Sub RemoveHyperlinks()

ActiveSheet.Hyperlinks.Delete

End Sub

4. Save your work.

5. Run your macro by pressing ALT-F8 or using the menu by Tools->Macro->Macros

6. Select the macro you have made, it should have the name ‘RemoveHyperlinks’.

Removing the Default Hyperlink Option

The most efficient way to remove them is by actually avoiding them in the first place. Now you don’t need to follow those hard and confusing steps above anymore. You can prevent Excel from formatting URLs and network links by removing its AutoFormat function at the AutoCorrect dialog box.

Unfortunately, if you are using Office 2003 or lower, i can’t give you the exact steps but the AutoCorrect is at Tools on the main menu bar. I just don’t remember where to go from there. If you are using Office 2000, there is no way we could prevent URLs from being formatted.

Post courtesy of: http://www.tildemark.com/removing-multiple-hyperlinks-in-excel/

Excel Macro – Get and Extract Hyperlink URL Address From Link

150 150 rhecht

This has personally worked like a charm for me.

Try this user-defined function:

=ShowAddress(A1)

Where A1 is the cell with the hyperlink in it. Here is the Macro function code:


Public Function ShowAddress(rng As Range) As String
If rng.Cells.Count > 1 Then
ShowAddress = CVErr(xlErrValue)
Else
ShowAddress = rng.Hyperlinks.Item(1).Address
End If
End Function

Note: With Excel 2007 and 2010 you first need to save a document as “.xlsm” to enable macros!

How to Create a Shortcut or Hotkey to Clear the Clipboard in Windows

150 150 rhecht

 

Have you ever copied something to the clipboard that you don’t want to leave there in case somebody else is going to use your computer? Sure, you can copy something else to the clipboard real quick, but can’t you just make a shortcut or hotkey to clear it?

And of course you can, with the built-in clip.exe utility in Windows 7 or Vista. It’s not really meant for clearing the clipboard, but with a little command line magic in a shortcut, we can make it do just that.

Note: This is also useful if you copied a very large amount of data to the clipboard and you don’t want it wasting memory anymore.

Create a Shortcut Icon to Clear the Clipboard

Right-click on the desktop or elsewhere, and choose New Shortcut from the menu.

Then in the shortcut location box, enter the following command:
cmd /c “echo off | clip”

At this point you’ll have an icon that will immediately clear the clipboard… but we can tweak it a bit further.

Right-click on the icon and choose Properties, and then change the Run drop-down to “Minimized” to make sure you don’t see the command prompt. You can also assign a shortcut key here.

If you click the Change Icon button and then browse down to this file, you can find a clipboard icon:
%SystemRoot%system32shell32.dll

Now we’ve got a nice-looking icon that will clear out the clipboard:

Note: If you are using Windows XP, you can download clip.exe from Microsoft. Just save the file in the Windows directory and the rest of the hack should work for you.

Thanks, Howtogeek.com!

DOS Command Line Remove Non Empty Directory Without Fuss

150 150 rhecht

​rd “directoryname” /s /q

Bonus: for Linux:

rm -Rf “directoryname”

That’s all! Was that so hard? Only thing is, be careful!

Microsoft Word Solution to Error “there was a problem sending the command to the program”

150 150 rhecht

Have you ever run into the error from Microsoft Word that “there was a problem sending the command to the program?” Well, worry no more! Here’s a solution.

Usually this is caused by the corruption in a specific registry key that’s associated by Microsoft Word. Deleting that key (backing it up first), and then restarting Microsoft Word should cause it to regenerate the key and its values, and this new uncorrupted key should solve the problem. No worries, there is no data loss whatsoever from this method.

This solution was found on Microsoft’s knowledge base website here (http://support.microsoft.com/kb/921541):

Delete the Word Data registry key

A screenshot on what you should do. Too many have complained about not finding this :-)

A screenshot on what you should do. Too many have complained about not finding this 🙂

To view these options in Word 2002 or Word 2003, click Options on the Tools menu.

To view these options in Word 2007, click the Microsoft Office Button, and then click Word Options.

Note When you delete the Word Data registry key, Word resets several options to their default settings. One such option is the “most recently used file” list on the File menu. Additionally, Word resets many settings that you customize in the Options dialog box.

To delete the Word Data registry key, follow these steps:

  • Exit all Office programs.
  • Click Start, click Run, type regedit, and then click OK.
  • Locate the following registry subkey, as appropriate for the version of Word that you are running:
    • Word 2002:
    • HKEY_CURRENT_USERSoftwareMicrosoftOffice10.0WordData
    • Word 2003:
    • HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0WordData
    • Word 2007:
    • HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0WordData
    • Word 2010:
    • HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0WordData
  • Click Data, and then click Export on the File menu.
  • Name the file Wddata.reg, and then save the file to the desktop.
  • Click Delete on the Edit menu, and then click Yes.
  • Exit Registry Editor.
  • Start Word.

If Word starts and works correctly, you have resolved the problem. The problem was a damaged Word Data registry key. You may have to change several settings to restore your favorite options in Word.

If the problem is not resolved, restore the original Word Data registry key. Then, see the “Delete the Word Options registry key” topic.

To restore the original Word Data registry key, follow these steps:

  • Exit all Office programs.
  • Double-click the Wddata.reg icon on the desktop.
  • Click Yes, and then click OK.

Voila! Your problem is solved!

Shortcut key – Remove all Hyperlinks in Microsoft Word Document

150 150 rhecht

How to remove all hyperlinks in a Microsoft Word document:

For Windows Users:

CTRL+A

CTRL+SHIFT+F9

For Mac Users:

COMMAND+A

Option 1: FN+COMMAND+SHIFT+F9

Option 2 (easier): COMMAND+6