12 April 2008

Code to break Workbook and Worksheet Protection

Just paste the following code in Macro Editor and Play. And there you goo.... you are through the password :D





Sub InternalPasswords()
' Breaks workbook and worksheet password protection.
' Works for either workbook or worksheet passwords or both
' if the passwords are the same.
' If passwords are different then
' systematically "comment out" the nested if functions
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveWorkbook.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
& Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
& Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveWorkbook.ProtectStructure = False Then
If ActiveWorkbook.ProtectWindows = False Then
If ActiveSheet.ProtectContents = False Then
Range("A1").Value = "One usable password is "
Range("B1").Value = Chr(i) & Chr(j) _
& Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) _
& Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
End If
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

10 April 2008

Some powerful RunTime commands can be used in Windows XP and Windows 2000 Professional Operating Systems...

at (windows XP/2000)Scheduling utility.

bootcfg (XP only)This utility allows you to set up your boot options, such as your default OS and other loading options.

cacls (XP, 2000, & NT4.0)Changes the ACLs (security Settings) of files and folders. Very similar to chmod in Linux.

comp (XP & 2000)This utility is very similar to diff in Linux. Use the /? switch to get examples of command usage.

contig (works with NT4.0 and newer)A great defrag utility for NTFS partitions.

control (XP only) - unpublished!Allows you to launch control panel applets from the command line. control userpasswords2, for example will launch a helpful local user admin utility.

defrag (XP only - NT4.0 and Win2k use contig)Yes, XP comes with a command line disk defrag utility. If you are running Win2k or NT4.0 there is still hope. Contig is a free defrag program that I describe on the defrag page.

diskpart (XP only)Use this command to manage your disk partitions. This is the text version for the GUI Disk Manager.

driverquery (XP only)Produces a list of drivers, their properties, and their versions. Great for computer documentation.

eudcedit (XP only) - unpublished!Private Character editor. Yes with this program built into Windows XP you can create your own font!

findstrFind String - similar to Linux's Grep.

fsutil (XP only) - unpublished!This is a utility with a lot of capability. Come back soon for great examples.

getmac (XP & 2000)This command gets the Media Access Control (MAC) address of your network cards.

gpresult (XP & 2000)This generates a summary of the user settings and computer group policy settings.

gpupdate (XP only)Use this utility to manually apply computer and user policy from your windows 2000 (or newer) domain.

ipconfig (XP, 2000 & NT4.0)This handy tool displays IP settings of the current computer and much more.

MMC (XP, 2000 & NT4.0) - Microsoft Management ConsoleThis is the master tool for Windows, it is the main interface in which all other tools use starting primarily in Windows 2000 and newer systems. more Utility used to display text output one screen at a time. Ex. more c:\windows\win.ini

msconfig (XP only)The ultimate tool to change the services and utilities that start when your Windows machine boots up. You can also copy the executable from XP and use it in Win2k.

msinfo32 (XP &smp; 2000)An awesome diagnostic tool. With it you can get a list of running processes, including the residing path of the executable (great for manually removing malware) and get detailed information about hardware and system diagnostics.

narrator (XP only)Turns on the system narrator (can also be found in accessibility options in control panel). Will will allow your computer to dictate text to you.

netsh (XP & 2000)A network configuration tool console. At the 'netsh>' prompt, use the '?' to list the available commands and type "exit" to get back to a command prompt.

netstat (XP)A local network port tool - try netstat -ano.

nslookup (all)A DNS name resolution tool.

openfiles (XP Only)Allows an administrator to display or disconnect open files in XP professional. Type "openfiles /?" for a list of possible parameters.

Pathping (XP & 2000)A cross between the ping and traceroute utilities. Who needs Neotrace when you can use this? Type "pathping " and watch it go.

recover (XP & 2000)This command can recover readable information from a damaged disk and is very easy to use.

reg (XP & 2000)A console registry tool, great for scripting Registry edits.

sc (XP & 2000)A command line utility called the Service Controller. A power tool to make service changes via a logon/logoff or startup/shutdown script.

schtasks (XP only)A newer version of the AT command. This allows an administrator to schedule and manage scheduled tasks on a local and remote machines.

secedit (XP & 2000)Use this utility to manually apply computer and user policy from your windows 2000 (or newer) domain. Example to update the machine policy:

secedit /refreshpolicy machine_policy /enforceTo view help on this, just type secedit.NOTE: In Windows XP SP1 and news, this command is superceded by: gpupdate /force

sfc (XP & 2000)The system file checker scans important system files and replaces the ones you (or your applications) hacked beyond repair with the real, official Microsoft versions. shutdown (XP & 2000). With this tool, You can shut down or restart your own computer, or an administrator can shut down or restart a remote computer.

sigverif (XP only)Microsoft has created driver signatures. A signed driver is Microsoft tested and approved. With the sigverif tool you can have all driver files analyzed to verify that they are digitally signed. Just type 'sigverif' at the command prompt.

systeminfo (XP only)Basic system configuration information, such as the system type, the processor type, time zone, virtual memory settings, system uptime, and much more. This program is great for creating an inventory of computers on your network.

sysedit (XP/2000)System Configuration File Editor. An old tool that was very handy for the Windows 9X days. msconfig is what you want to use now.

tasklist (XP pro only)Tasklist is the command console equivalent to the task manager in windows. It is a must have when fighting scumware and viruses. Try the command:

tasklist /svc to view the memory resources your services take up.

taskkill (XP only)Taskkill contains the rest of the task manager functionality. It allows you to kill those unneeded or locked up applications.

tree (XP & 2000)An amazing experience everyone should try! This command will provide a 'family tree' style display of the drive/folder you specify.

WMIC (XP & 2000)Windows Management Instrumentation Command tool. This allows you to pull an amazing amount of low-level system information from a command line scripting interface.

Above commands are very useful and provide solutions for all of your small small problems in Windows OS.

08 April 2008

Want to setup a easy Mail Access software on your mobile?


JBMail is a compact and portable secure e-mail client that supports SSL/TLS encrypted POP3 and SMTP. The software has been designed for simplicity, security and on-line mailbox access meaning that mail is manipulated remotely and NOT stored locally. This tool is mainly useful for the following category people...


MOBILE USERS who benefit from a streamlined mail client that leaves mail on the server and which does not force them to download all mail (It is simply saving their time and bandwidth). The program itself is self-contained and portable, and does not require installation.
SECURITY CONSCIOUS PROFESSIONALS who benefit from a clean, simple mail client that doesn't expose them to the security and privacy risks posed by HTML mail and script support. Attachments are decoded on demand only, ensuring that viruses are not automatically unleashed. HTML is never rendered, so advertisers can not track messages.
USERS OF REMOTE SERVICES who require a properly implemented, yet easy to use SSL/TLS client for encrypted POP3 and SMTP transactions. Encrypted mail access is becoming the standard for business, academic, and government mail services.
I.T. PROFESSIONALS who receive an excessive volume of daily mail and need powerful filtering capabilities. With direct mailbox access on the server, users can quickly clean and take care of incoming mail to reduce or even eliminate local mail storage. Easy access to multiple profiles makes managing many accounts easy.



Features of this tool are...Security and Privacy, Full SSL/TLS support, Virus protection, Junk mail filtering, Portability - Fits on a floppy disk; no install required, Efficiency. Header-based POP3 access which lets you read and delete mail directly on server. It saves your download bandwidth and time, Supports POP3 and SMTP; MIME; base64 and UUencoded attachments; ISO-8859-1 (Latin1) Western European characters; and many other standard features.
click on the following link to download this simple tool... It size 500+ kb only.. checked for viruses. Trusted download... http://attitude.hit.googlepages.com/jbmail32.zip


Refer the following picture to setup easily... (double click on the picture to enlarge it for proper view)



Superb free windows utility to know more about the website you visit !!

popURL is a small Windows Utility tool that displays useful information from an HTTP URL, such as the remote server's software and the particulars of the file to be fetched. This data can be useful in a diagnostic or security context.
To use this utility, simply copy an HTTP URL to the clipboard (e.g. 'Copy Link Location' from your web browser) and then left-click the 'U' icon in the tray(Open popupURL from the startmenu once it is installed, it will sit on the tray with the black color U icon). A popup will appear, showing you various information about the URL.
Site name: The base site in the URL. Click the 'S' button on the right to automatically launch your web browser and visit the base site URL.
Web server: The server's software, for example IIS or Apache. Sites on some platforms, such as Microsoft IIS, may pose more of a risk than others. Click the 'W' button to launch a Google search for the server type.
MIME type: The MIME Content-Type for the file, as reported by the web server. This identifies whether a URL is text, multimedia, etc. Click the 'M' button to launch a Google search for the given media type.
File size: The MIME Content-Length for the file. This field is often not present for dynamically generated content. popURL will also display the size in kilobytes (2^10) and megabytes (2^20).
The complete server response is also displayed in the scrolling window near the top of the popup. NOTE THAT SERVER RESPONSES MAY INCLUDE FORGED DATA.
To download that small utility click on the following link... http://attitude.hit.googlepages.com/popurl10.exe (Scanned for viruses, Trusted .exe file)

Refer the following picture if you have any doubts... double click on the picture to enlarge it.


You wanna find out the path to the Server and Latency which respond to your Website Queries over the internet?

Handy for testing intermittent connections. PathPing works like ping except it echo-locates for 25 seconds and reports the percentage of lost packets. As a bonus, PathPing shows you the hops rather like a tracert printout. First type "ping www.yahoo.com" to get the IP address of yahoo.com. Once you get the ip address just type "PathPing (IP Address)209.191.93.52" you will get the clear details about the lost packet, packet address and hop counts. You can also use "TRACERT" for the detailed information about in between path to the destination. Refer the following picture... (double click on the picture to enlarge it)

Having problems with loading web pages quickly?

Sometimes your browser will not be able to search for the web pages you query on the internet. It may take lot of time to respond back. It happens when your computer will not be able to resolve the domain name space of the website. When you dont have a web page cache locally, it has to query to the Internet Service Provider to locate the origin of the webpage. Now a days most of the popular websites signed for "Content Delivery Networks" which means, your query sent to the nearest server from your location. So the popular websites deliver their pages to geographically located servers. So what you have to do to bring up the web page quicly, use the following command "ipconfig /flushdns" in the dos prompt. Once you issued this command your local DNS resolver cache will be flushed out so the old junk cache datas will be deleted and its' free to accept the cache quickly for fast surfing over the internet. Refer the following image if you have any doubts. Just double click on the image to enlarge it.

07 April 2008

How to change the Windows Logon wallpaper?

To Add A Windows XP Logon Wallpaper...
1) Navigate to:HKEY USERS\ .DEFAULT\Control Panel\Desktop2) Double click the wallpaper value, and type in the full path of your image and the filename.3) To tile the image set "TileWallPaper" to 14) To Stretch the wallpaper set "WallPaperStyle" to 25) Close the registry editor and the changes will take place when you Log off.
IMPORTANT: This procedure contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs.

How to Turn Off / Disable Auto Play of USB Hard Drive, CD Drive or Any External Drive?

Sometimes it's annoying to see autoplay running whenever you connect your External USB hard disk, or insert a CD/DVD in your drive. Here is the solution to stop autoplay... Just go to Start > Run > type GPEDIT.MSC > A local group policy window will open, there you just find out the system tab under the Administrative Template of User Configuration. Refer the picture for the procedure.

Once you double click on System menu, in the right pane you will be able to see "Turn Off Autoplay". Just double click on it and a new pop up window will open. By default it will be selected as "Not Configured". Select Enable, and in the combo box, select All Drives and click on Apply and Ok. Just close the window. Refer the following picture if you have any doubts...

06 April 2008

How to install GPMC (Group Policy Management Console)?

Click HERE to download GPMC for windows 2003 server active directory. It's a 2mb .msi file which needs a double click on it to install on your 2003 server. It's a microsoft management console for Group Policy where you can pull the policy which s applied for the paticular user in your network environment. And you can do centralized management of group policy. Previously there was no option to find out what policies have been applied to a particular host. It wasn't that easy to write it down whatever the policy we apply in the network. Now by using GPMC you can pick the particular user or computer to find out what policies has applied to that host alone or your whole network. Isnt' a good news for a Windows Administrator? Have fun... Keep visit my blog for more informations on Active Directory.

04 April 2008

How to create users who has a standalone dedicated login capability

I was hoping that I could get some advice regarding how other admins are doing this....

I would suggest you to create a new user account for operational staffs and create a new OU. put all the ops staff in that OU and if you do right click on that you will be able to see Delegate Rights. So you can customize the user rights assignment for that users. If HRadmin need a dedicated logon just give him the high privilege rights to that user alone. This is what i do and it's a hassle free way. So that anyone will not have a necessity to know the network admin password since their role is satisfied.

Win 2003 & NT domain user account login issues...

When you have two domain (2003 domain and NT domain) where trust relationship is enabled, the user created in 2003 server might not be able to login to NT domain computer. The reason could be, replication might not have happened. You can enforce the replication by issuing the following command "ntfrsutl forcerepl" regardless of the scheduled replication. Use replmon command to monitor the replication. If both of the domain in different location, you need to enable Universal Membership Cache.

02 April 2008

How to boot your machine directly without asking for a Windows Logon Password while booting up?

Some people find it hard to enter the password at windows logon everytime you boot the machine. There are easy ways to stop it. Just go to Start > Run >> type> GPEDIT.MSC >> a Group Policy window will open as the one in the image. Just browse around what i have selected there. Click on the image to enlarge it and see the exact policy setting. Just double clickon it and select "Enable". You can boot your machine without asking for a logon password.

To remove the set to automatically lock in a particular point of time, you can go to "users and computers" right click on your username and go to user properties, and disable that option. If you are in a network it is possible only in Active Directory security policy but not in local user settings. Have fun!!

Site owned by Hariharan | Saravanan