15 June 2009

Excel macro to get MAC address of computers

Here is a very simple Excel to get the MAC address of a computer

Function Get_MAC_Address(strComputer)     Set objShell = CreateObject("WScript.Shell")     Set objFSO = CreateObject("Scripting.FileSystemObject")     On Error Resume Next     objFSO.DeleteFile "D:\MAC.txt", True     On Error GoTo 0     objShell.Run "cmd /c NBTSTAT -a " & strComputer & " | FIND ""MAC Address"" > D:\MAC.txt", 0, True       Set objMACFile = objFSO.OpenTextFile("D:\MAC.txt", 1, False)     While Not objMACFile.AtEndOfStream         strLine = objMACFile.ReadLine         If Len(strLine) > 35 Then             strMAC = Mid(strLine, 19, 17)         End If     Wend     objMACFile.Close     Set objMACFile = Nothing     Set objShell = Nothing     Set objFSO = Nothing     Get_MAC_Address = strMAC End Function

Excel macro to ping computers

Here is a very simple function that you can use in Excel to ping network assets

Function Ping(strComputer)

Dim objShell, boolCode

Set objShell = CreateObject("WScript.Shell")
boolCode = objShell.Run("Ping -n 4 -w 300 " & strComputer, 0, True)

If boolCode = 0 Then
Ping = True
Else
Ping = False
End If

End Function

02 June 2009

Mail PassView v1.51 - Extract lost email passwords

Mail PassView is a small password-recovery tool that reveals the passwords and other account details for the following email clients:

Outlook Express
Microsoft Outlook 2000 (POP3 and SMTP Accounts only)
Microsoft Outlook 2002/2003/2007 (POP3, IMAP, HTTP and SMTP Accounts)
Windows Mail
Windows Live Mail
IncrediMail
Eudora
Netscape 6.x/7.x (If the password is not encrypted with master password)
Mozilla Thunderbird (If the password is not encrypted with master password)
Group Mail Free
Yahoo! Mail - If the password is saved in Yahoo! Messenger application.
Hotmail/MSN mail - If the password is saved in MSN/Windows/Live Messenger application.
Gmail - If the password is saved by Gmail Notifier application, Google Desktop, or by Google Talk.

For each email account, the following fields are displayed: Account Name, Application, Email, Server, Server Type (POP3/IMAP/SMTP), User Name, and the Password.

http://www.nirsoft.net/utils/mailpv.html

29 May 2009

Google Wave: Communication and Collaboration plateform

Check out the developer preview at Google I/O

Google Wave is a new tool for communication and collaboration on the web, coming later this year. Watch the demo video below, sign up for updates and learn more about how to develop with Google Wave.

http://wave.google.com/

15 April 2009

Better than Vista’ Snipping Tool? Cropper is there!

Cropper is a screen capture utility written in C#. It makes it fast and easy to grab parts of your screen. Use it to easily crop out sections of vector graphic files such as Fireworks without having to flatten the files or open in a new editor. Use it to easily capture parts of a web site, including text and images. It's also great for writing documentation that needs images of your application or web site.

http://cropper.codeplex.com/

Cropper also has a collection of plugins for exporting screenshots in various format

http://www.codeplex.com/cropperplugins

Cropper works on Windows XP and Vista and is much better than the Vista built in Snipping tool.

14 April 2009

Issue to reinstall Google Chrome

After changing computer, I had some issues to reinstall Google Chrome.

I found the the log of the Google Chrome installer

1. Start > Run

2. %USERPROFILE%\Local Settings\Temp + [Enter]

The file’s name is chrome_installer.log and mine was saying that an higher version was already installed. This problem happened because I was previously registered as a Google Chrome Beta tester and the downloader would not let me download previous versions.

In order to be able to reinstall it, I found the following workaround.

1. Open regedit (start > run > regedit)

2. Browse to the following key [HKEY_CURRENT_USER\Software\Google\Update\Clients\{8A69D345-D564-463c-AFF1-A69D9E530F96}]

3. Change the [pv] value to 1.0

4. Rerun the install from http://www.google.com/chrome

This should allow you to reinstall Google Chrome.

02 April 2009

Free Foreign Language Lessons

A great way to learn 37 languages for free. Spanish, French, English, Mandarin, Russian and much more. Why pay for Rosetta Stone when you can learn a new language for free.

http://www.oculture.com/2006/10/foreign_languag.html