No system is an island - Windows tips and tricks for all.

Viewing and editing macros in Excel 2007

avp@mail.org (AVP) — Sat, 27 Jun 2009 06:50:00 +0000

Office 2007 makes a complete overhaul of user interface from previous versions of Microsoft Office.

In Excel 2007,editing and viewing spreadsheet macros is now under a Developer tab group which is not enabled by default.

Here is how to enable the Developer tab which gives access to macros settings :

Open Excel 2007.

On top left,click on the Office button (yes that is a new shiny round button not present in previous Office versions)

Select Excel Options,in the Popular tab,check the Show Developer Tab in the ribbon option.

Once done,there will be a Developer tab in the main spreadsheet UI from where excel macros can be coded,viewed,tested and so on.

Cheers.

Turn off DEP in Vista

avp@mail.org (AVP) — Fri, 26 Jun 2009 07:04:00 +0000

Data Execution Prevention (DEP) monitors programs and how they run from system memory,this results in many applications getting blocked by DEP in Vista.

It can be turned off or customized as per liking,the quickest way to turn on/off DEP is through the almighty command prompt.

Launch command prompt with administrator rights and type the following :
bcdedit.exe /set {current} nx AlwaysOn

This turns on DEP for all applications,not fun at all when you can't install any program after this command is executed :)

To turn off DEP,which is usually the case especially when games that run on XP without a glitch suddenly stop working on Vista (Manhunt comes to the mind) :

bcdedit.exe /set {current} nx AlwaysOff

In both the above commands,a restart will be necessary before the changed DEP settings can come into effect.

Enjoy.

Migration from Windows Mail to Outlook 2007

avp@mail.org (AVP) — Sat, 02 May 2009 13:19:00 +0000

Migrating emails from Windows Mail to Outlook 2007 is quite straightforward.

To move all messages from Windows Mail to Outlook 2007,open Outlook 2007(Start > Run > outlook).

Go to File > Import and Export.

Select Import from another program or file.

Select Outlook Express 4.x,5.x,6.x or Windows Mail.

If you have multiple email accounts configured,there will be an option to select each of them (can't select all of them at same time).

Once the migration starts,associated password with each email account will be required and the messages will be moved to Outlook 2007.After it is complete,the entire folder structure as in Windows Mail will now appear in Outlook 2007 along with all emails.

The one major disadvantage is lack of compatibility of mail rules between Windows Mail and Outlook 2007 due to which the Windows Mail rules won't work in Outlook 2007.

Happy emailing.

How to view all Task Manager processes

avp@mail.org (AVP) — Wed, 22 Apr 2009 15:21:00 +0000

Task Manager in Vista by default only shows processes by current user.

To see processes from all users,launch Task Manager (Start > Run > taskmgr)

Administrator access will be needed in order to view all processes.

Navigate to Processes tab and simply check the option "Show processes from all users"

Before :

After :

Notice how various processes related to different Windows components have now appeared in task manager,this becomes very useful during troubleshooting Vista.

All done.

Booting Windows in safe mode automatically

avp@mail.org (AVP) — Fri, 03 Apr 2009 06:10:00 +0000

There are times when one needs to use safe mode in Windows either to remove malware or fix some corrupted system files and so on.

Here,it can be annoying to keep hitting F8 on every restart just to get into safe mode for troubleshooting as missing that will start Windows in normal mode.

Msconfig helps in making Windows boot in safe mode always.

In Vista :

1.Go to Start > Run > msconfig.

2.Select Boot tab and check the Safe boot option with sub option as Minimal.

3.Click Ok and select Exit without Restart option.(The settings will be applicable only on the next restart).

4.Restarting Windows with the above settings will now directly launch safe mode.

5.Remove the check mark on Safe boot to reverse these changes once work is done in safe mode.

Happy troubleshooting in safe mode.

Cheers.

How to open excel spreadsheets in different windows

avp@mail.org (AVP) — Sat, 21 Mar 2009 07:16:00 +0000

Microsoft Excel by default launches different Excel sheets within the same window.

This is often time consuming when there are multiple sheets involved as each one needs to be minimized and then restored again.Arranging sheets side by side is useful only to an extent but not much.

A simple setting can make different Excel sheets open in different windows which becomes very convenient when using multiple monitors.

To do this,launch excel (Start > Run > excel.exe)
Go to Tools > Options > General.

Check the "Ignore other applications" option.
Close excel and relaunch.
Different spreadsheets will now open in different seperate windows.

Hope this has been a useful post.

Using web query in Microsoft Excel

avp@mail.org (AVP) — Sat, 28 Feb 2009 08:51:00 +0000

I am no Excel buff but this application has some really neat features which we normally aren't aware of during general use.

What if I want some data to be stored in Excel sheet from a web page and then regularly update that data from the internet?

It can be done in a jiffy within Excel using the Web Query option.

Open Excel (Start > Run > excel.exe)

Go to Data > Import External Data > New Web Query.

This will open a browser within Excel (it is IE),go to website (here I am using finance.yahoo.com) and select the tables that you want to import using the yellow arrow button.

Selected tables here will be tick marked and once done,hit the Import button.

This will prompt for data placement(the cells where you want the data to appear),select as appropriate and voila - all the table values from webpage are in Excel.

Now,whenever updation is needed,right click any of the imported table cell and select Refresh Data.

This will update the data after fetching it from the website source.(Basically,the web query will run again and import the data.)

There are macros which can also automate the refreshing of data,I will post more on that after some time.

Happy Exceling.

Peace.

Using Morning Coffee Firefox add-on

avp@mail.org (AVP) — Mon, 09 Feb 2009 14:08:00 +0000

Some Firefox add-ons are pretty cool.
Morning coffee is an add-on that basically stores sites that are frequently visited as a list and slotted as per weekdays.This eliminates the daily chore of opening the same websites in multiple tabs again and again daily.

Download the add-on from here.Using it is very simple and effective too.Once installed,the coffee cup icon will show up in Firefox navigation panel.

To add websites that should open as per scheduled weekdays,click on the coffee cup icon and select Configure.

This brings up a window where all websites can be added as per preferred weekly schedule.

All done.

How to reset Windows Mail

avp@mail.org (AVP) — Mon, 02 Feb 2009 14:13:00 +0000

Recently Windows Mail started freezing whenever I wanted to reply to or compose new emails.

This can be fixed by resetting Windows mail registry settings.

Let's take a look on how to reset that setting and bring back Windows Mail back to normalcy.

Close Windows Mail if it is running.

First we need to back up the associated registry key of Windows Mail.
Launch registry editor (Start > Run > regedt32) with admin privileges and drill down to:

HKEY_CURRENT_USER\Software\Microsoft\Windows Mail

Select export and store the key.

Once done,delete it.

Launch Windows Mail,this will make a new key with clean settings.

Most of the Windows Mail problems can be fixed by this method,although a backup of the key being deleted is a must.

Happy emailing.

Creating new partition in Windows Vista

avp@mail.org (AVP) — Sat, 24 Jan 2009 13:04:00 +0000

Windows Vista comes with in-built partition creation which makes it possible to make new partitions on fly from Vista.This takes care of basic partitioning needs without purchasing any extra application.

Say if we have Vista installed on a single disk with no partition,we can shrink this single disk so as to have a new partition without the use of any external partition sizing utility.

With administrator privileges,go to Start > Run > diskmgmt.msc

Select the volume that needs to be shrinked (i.e from which a new partition needs to be created).
Right click and select Shrink Volume.

Specify the size (this will be restricted based on the current disk space utilised on current volume and also size of paging file and other system parameters in case the system volume is to be shrinked).

Select Shrink.
Once complete,there will be a unformatted volume created,format it as per choice (NTFS/FAT32) and label it.

All done.

How to run DOS applications on Windows Vista

avp@mail.org (AVP) — Sat, 17 Jan 2009 05:29:00 +0000

Some things are addictive no matter how old they get,like playing DOS based games for instance.

Have you ever wondered how will good old DOS run in Windows XP/Vista boxes?
There is a cool free utility that allows you to do just that.It is an emulator of sorts which provides you all the retro DOS features in your shiny new Windows.

It is named DOSBox and the best thing it does is the ability to run really nice DOS games under Windows,all that for free.Let's take a look on how to go about installing and configuring it.

Download it from here first.

Run the setup with administrator privileges,installation is quite visual.Once installed,you can see a desktop icon like this :

Double click to run the application,there will be a familiar good old DOS console :

To run any DOS application,first we need to mount a drive in DOSBox which contains the executables.The following command gives the correct syntax to do that :

intro mount

Here,I am mounting a folder which has Mortal_Kombat arcade game as a drive in DOSBox.
The game folder resides on D Drive on my Vista machine,I am assigning it drive letter G in DOSBox,the full command looks like this :

mount g d:\Arcade\Mortal_Kombat

I will verify that the G drive is listed correctly with the specific folder :

All done,now just like in good old DOS days,type the executable file name to launch the program in full glory of DOS by navigating to the mounted drive - g: in this case.

To quit DOSBox,simply type "quit" to close the shell.

Playing DOS based games kind of brings back old memories,doesn't it?

Peace.

Prevent Vista from automatic restarts

avp@mail.org (AVP) — Sat, 10 Jan 2009 05:39:00 +0000

To fix an error,you should first know the error and then find out what causes this error.

System errors in Windows occur all the time(the pretty blue screens of death).The default settings Vista (or even XP) is configured with is to simply restart on own.

While this is a common way of troubleshooting errors,not all system errors can be fixed by a simple reboot.It is important to get details of errors when they happen so they can be analyzed.

To prevent Vista from auto-rebooting whenever a system error happens,navigate to Start > Settings > Control Panel > System > Advanced Settings.

Select the Startup and Recovery tab and uncheck the automatically restart option.Click OK to save the changes.

Doing this will ensure that Vista in event of a critical system error will come to a halt which in turn helps in seeing the error (error codes/description in case of blue screen).

Hope this has been an informative post.

How to activate screensaver easter eggs in Vista

avp@mail.org (AVP) — Tue, 23 Dec 2008 09:50:00 +0000

Vista comes with a lot of easter eggs and some of them use screensavers to get activated.

Remember the cool swirling colorful screensaver in Mac OSes?

This same type of screensaver (Aero screensavers in Vista) can be set as a desktop background using the easter eggs.

I will show the most common ones in Vista.Do note that the activated easter eggs will lock the access to Windows desktop (with desktop icons vanished)and they can be terminated anytime using the Alt + F4 key or from task manager by ending the associated .scr process.

Open command prompt (Start > Run > cmd)with administrator privileges.
Go to Windows\system32 directory.

Type the following each for a different easter egg:

1. ribbons.scr /p65552
2. aurora.scr /p65552
3. bubbles.scr /p65552
4. mystify.scr /p65552

The interesting thing here is when this is done on a dual display system with extended desktop.The primary display will have the easter egg active while the secondary display will still have the original Vista wallpaper.

Feel free to mess around with these eggs,they are very cool.

Peace.

Configure 32-bit Vista to recognize more than 4 GB RAM

avp@mail.org (AVP) — Sat, 20 Dec 2008 13:17:00 +0000

Windows Vista 32-bit version shows less than 4 GB RAM installed when in fact that capacity is actually installed due to 32-bit architecture limitations.

It is not necessary to expect that if you install more than 4 GB RAM in Vista,it will provide better performance because it can't see more than the above limit by default.If you really need to leverage more,than use the 64-bit Vista versions for better performance.

Anyway,the amount of RAM that can be recognized by 32-bit Vista can be changed by the in-built bcdedit command.BCDEDIT - Boot Configuration Data Store Editor is what was boot.ini in earlier Windows versions.

To change the memory capacity to more than 4 GB,use the following command from command prompt with administrative privileges:

bcdedit /set PAE forceenable

Successful output will show operation completed successfully.

What this command does is enable Physical Address Extension (PAE) within the boot config store to see more RAM present in Vista.

To reverse the command,simply type at command prompt :

bcdedit /deletevalue PAE

For more technical info on this,this Microsoft KB article is the place to be.

Hope this has been an informative post.

Transform Vista into Mac OS X

avp@mail.org (AVP) — Sat, 20 Dec 2008 05:53:00 +0000

There are some great themes for Windows Vista but one really cool theme is the Vista to Leopard transformation pack.

Download it from here.

Installing it is quite straight forward.Once the setup is downloaded,run it.

Accept the license agreement and select All the options for the best possible effects of the OS X transformation pack.

Once setup is complete,reboot Vista once.The start and shutdown screen in Vista will now be that of Mac OSX.

To apply the theme,right click on Desktop and select Personalize > Theme.

Select VistaOSX theme and apply the changes.

Notice that how the Vista wallpaper changes to that of Leopard and the dockable bar appears just like in OS X.

The Windows logo is now replaced with Apple logo (yes it is the same Microsoft Windows,just the theme has changed :) ).

Enjoy.

Using Performance Information and Tools in Vista

avp@mail.org (AVP) — Sat, 20 Dec 2008 05:28:00 +0000

Windows Vista comes with a handy set of tools for diagnosing and troubleshooting system problems.This is under the "Performance Information and Tools" section.

Wouldn't it be handy if we can glance at all the system issues in one go and can immediately correct them?

Vista provides this capability of reporting existing system problems and also fixes them on own be it an outdated driver or some system settings that are not compatible with the system.

Go to Start > Settings > Control Panel > Performance Information and Tools.Click on the Advanced Tools link.

Notice the Performance issues tab there.This will have all the problems that exist in Vista and which can be fixed in a jiffy.

Here Vista has reported display settings as sub-optimal.Clicking on the problem will pop up a dialog box with a very useful event viewer link pinpointing the reported problem that helps in tracking down the exact error in Vista.

This feature saves a lot of troubleshooting time as well as ensures that all reported problems can be fixed on own by Vista like a self tuning system.

Hope this has been an informative post.

Peace.

Using Core Temp to check CPU temperature

avp@mail.org (AVP) — Sun, 14 Dec 2008 05:10:00 +0000

Processors generate a lot of heat and this can be a reason for many computer problems like random restarts,abrupt shutdowns and so on.
The overheating becomes amplified in case of dual processor systems and hence it is essential to at least have some kind of tool that reports the processor temperature.

Core Temp is a very small yet quite handy tool for this purpose.It reports the temperature of each individual core in each processor in your system real time and is completely motherboard independent.

Using it is as simple as it can get.Launch the executable file of Core Temp and notice how it displays the temperature of cores in a system :

Just like all reporting tools,the information can be logged for future references and the tool can be customized by going to Options > Settings.
Select the Enable Logging option and save the changes.

This will now generate a csv file in the directory where Core Temp is installed named Temp Log.csv

The visual indication of core temperature can be directly found in system tray with blue and red digits which are the reported temperatures of core.

Feel free to give Core Temp a try,it is quite useful.

Peace.

How to configure telnet in Windows Vista

avp@mail.org (AVP) — Tue, 09 Dec 2008 06:25:00 +0000

Windows Vista by default doesn't come with Telnet service installed.

If you use remote login extensively to connect to a Vista system,I would recommend SSH for that as it is far more secure than telnet which doesn't encrypt communication between client and server.

Installing telnet(client as well as server)in Vista is quite a straight forward process.By default,if command "telnet" is issued in Vista,you will see an error message like this :

In XP,Add/Remove Programs used to install many services like IIS etc which by default didn't come installed.

To install telnet on Vista,go to Control Panel > Programs and Features > Turn Windows features on or off.This will need administrative rights.

Here select both - telnet server and client.An information box will pop up after this indicating that the selected services are getting installed on Vista :

Once installed,type telnet at the Windows command prompt and this time,it will show the console for telnet connections.

We have installed telnet client as well as telnet server.However telnet server service needs to be started from services console so that incoming telnet connections are accepted by the Vista system.

Go to Start > Run > services.msc and select Telnet,right click on Properties and hit the Start button for the service to start.

We now have configured Vista to accept inbound Telnet connections(server) as well as to connect to other Telnet supported devices(client).

All done.

Hope this has been an informative post.

How to release and renew IPv6 address in Windows Vista

avp@mail.org (AVP) — Tue, 09 Dec 2008 05:55:00 +0000

Till Windows XP,there was no extended support by default for IPv6,only for IPv4 addresses (those are 32-bit in length like 10.10.1.1,255.255.255.0 and so on).

With Vista comes the in-built support for IPv6 addresses (these are long ones with 128-bit length like 2002:c058:6301::c058:6301)which can't be removed unlike in XP. So if we want to renew or release dynamic IP addresses depending upon their type like whether they are IPv4 or IPv,we can do that quite easily thanks to the cool set of IPv6 commands that come bundled with the ipconfig tool in Vista.

Finding which commands works with IPv4 or IPv6 in ipconfig is easy.
Go to Start > Run > cmd and in the command prompt,type ipconfig/?.

This will display all associated commands that can be used with ipconfig :

Note the commands with 6 as the suffix - /release6 and /renew6.
These take care of IPv6 addresses in releasing them and reassigning them in case the system takes dynamic IPv6 addresses from a DHCP server.

For dynamic IPv4 addresses,the good old commands - ipconfig/release and ipconfig/renew still hold true,the new command above are only for IPv6 dynamically assigned addresses.

Peace.

How to install Roboform add-on in browsers

avp@mail.org (AVP) — Sat, 29 Nov 2008 05:58:00 +0000

Roboform is an automated application to fill web based forms and it can be easily installed as an add-on to browsers to manage and fill forms efficiently.

To install it,go to this add-on link for Internet Explorer.

The same link can be reached by selecting Tools > Manage Add-ons > Find more add-ons in Internet explorer.

Click on the download link and save the setup.

Once done,launch the roboform setup.

In customizing the setup,select the option 'Install adapter that allows Roboform to work in Firefox',this will install roboform in Firefox as well.

Now comes the important part of entering a master password which controls access to all the stored data in roboform.

Make sure that a good easy to remember password is used here.

Once the setup is complete,the roboform add-on will show up in Internet Explorer as well as in Firefox.

All done installing roboform.

How to use Putty to connect via SSH

avp@mail.org (AVP) — Tue, 18 Nov 2008 16:55:00 +0000

In earlier posts,I had shown how Windows Vista can be setup as a SSH server.

Now,let's see how we connect using ssh to this configured server.

For this,any ssh client will do,Putty is highly recommended and it is free.

Get the entire pack of Putty for Windows which supports most of the connection types from here.

Install it with administrative privileges and launch the Putty terminal.

Enter the IP address or the host name of the system that you will connect to using Putty.Since we want to access via ssh,the option SSH is selected as connection type,note that port number automatically changes to 22 once this is selected.

Once the IP/host name along with the connection type is entered,it is better if we save this as a session so that going forward we can simply load this session.Here,this is saved as AVP-BOX.

To connect,hit OK.

The following warning message should show up when connecting for the first time :

This ideally should come only when you are connecting to the remote system for the first time because the subsequent logins will have the physical address of the system (the network card which accepts the connections) cached in the client machine's registry.

This warning also pops up after say a network card of the server is changed thereby changing the original physical address which needs to be cached again on the client system.Anything apart from this can be a potential MITM attack scenario.

The login prompt will ask for the user name and password (ideally administrative privileges),once correctly entered the prompt shows up and you are now managing a remote system via ssh using Putty.

To close the connection,type exit at the prompt.

Enjoy.

Using task manager in Vista for managing services

avp@mail.org (AVP) — Sun, 16 Nov 2008 04:52:00 +0000

Windows Vista task manager is greatly improved.It comes with useful additional features of managing services and also of file tracking based on the services running.This proves helpful if we want to manage services directly and see their application/system files from task manager instead of going to (Start > Run > services.msc) routine.

Launch task manager (Right click on taskbar and select Task Manager or by Start > Run > taskmgr).Click on Services tab and this will show a list of services (stopped as well as started).Those services whose PID columns are blank instead of a number are the ones that are stopped or simply see the Status column.

Suppose I want to start the service netlogon.

I will right click on service and select Start Service,this will now start showing a PID as the service is now running.

Tracking down a service is also quite simple,right click the service whose info is needed and select Go to Process.
Here I use EvtEng service to track down it's process and then use that process info to see where the files are really located for this.

This will track that service to it's associated process which helps us to know which application or which system function is owning that process and hence the service.

Once the process window is opened with the tracked process,right click on Go to File which will open the actual path of application along with the highlighted file that owns the process.

This is a great way to troubleshoot errors where you can't seem to know which process is doing what but tracking its files will give a clear view on how to go about fixing it.

Hope this has been an informative post.

Peace.

How to use junk email options in Windows Mail

avp@mail.org (AVP) — Sat, 15 Nov 2008 05:07:00 +0000

We all dislike junk emails or unsolicited emails that offer free stuff.
Windows Mail has some useful features that allow control over junk emails that we receive.

Have you ever found that sometimes emails sent by friends/acquaintances end up in junk email folder in Windows Mail?

This can be easily prevented especially if the email address is of a person that you had sent an email earlier to.

We will configure Windows Mail to never allow emails sent from a particular address to be marked as junk,the important condition being that this email address was actually replied to by us earlier.

Let's take a look on how to use the various options related to junk emails filtering in Windows Mail.

Open Windows Mail (Start > Run > winmail)
Go to Tools > Junk Email options and then Safe Senders tab.Check the box that displays "Automatically add people that I email to safe senders list".

By default,the junk emails filtering in Windows Mail is set to low.This can be changed from the tab Options.

Do note that the more aggressive the filtering is set to,the greater will be the probability that non-junk emails will be marked as junk.

One option that we need to be particularly cautious about is the deletion of junk emails.If that is set,then any email marked as junk will be permanently removed instead of even going to the junk email folder.This can be troublesome if useful emails are flagged as junk,best bet will be to leave the option as it is.

Now let's take a look at domain wide filtering.
Any email ending with a same domain name like @spammers.com can be blocked if we add that domain in blocked senders list.

To do this,click on the Blocked Senders tab,then the Add button and enter a domain name.

Here I use spamcompany.com for illustration.This will block any email with that domain name in reaching the inbox.Individual addresses can also be added to the blocked senders list.

Many times,we get junk emails with a specific country code like .ru or .za and so on.This too can be blocked by blocking the top level domains (TLD).

Go to International tab and hit Blocked Top Level Domain list.

This will show all the possible TLDs,select as required and click Ok.(I have set .ru as a blocked TLD in this case.)

Feel free to play around with the junk email settings in Windows Mail,they are pretty much flexible and easy to configure.

Hope this has been an informative post.

How to make a batch file for fixing CTF errors in AVG antivirus

avp@mail.org (AVP) — Fri, 14 Nov 2008 02:58:00 +0000

In my earlier post on fixing the Invalid Update Control CTF error which pops up while upgrading the definition files in AVG antivirus,I had shown how to delete the .ctf files and then upgrade the definition files to make the error go away.

Instead of doing the same set of tasks,why not make a simple batch file which will does all the steps described? All that we need to do then is run it when the error shows up.

To make a simple batch file for this,open any text editor like notepad (Start > Run > notepad.exe)

Type the following commands there :

cd \
cd c:\ProgramData\Avg8\update\download
del *.ctf

This is for Vista where the AVG ctf files reside in ProgramData symlink.

The batch file will go to the root drive,from there change the directory to ProgramData\AVG8\update\download and delete all the files with extension *.ctf.

For XP,the only change will be the path :

cd \
cd C:\Documents and Settings\All Users\Application Data\avg8\update\download
del *.ctf

Once done,save the text file with a .bat extension and a sensible name with Save As type All files.

You will see that the icon changes to that of a batch file.

That's it.

Run the batch file when you get the AVG error and see the charm of a basic batch file :)

Peace.

How to use Windows Mobility Center

avp@mail.org (AVP) — Thu, 13 Nov 2008 07:14:00 +0000

Laptop users have some common tasks because of their mobility.

Connecting laptop to a monitor,switching wireless radio on or off,charging the laptop are some of the most common of them.

Everytime these tasks need to be done,laptop users need to go to Control Panel and change settings which can be cumbersome after a while.

Is there any way these tasks can be carried out from a single dashboard like interface?

And this is where Windows Mobility Center steps in.

Using the center is easy,simply go to Control Panel > Windows Mobility Center or press Windows key + X to open it in a jiffy.

From a single interface of Windows mobility center,laptop users can :

1.Connect laptop to external display.
2.Charge their laptops and select power schemes.
3.Turn wireless on or off.
4.Adjust sound properties.
5.Control brightness.
6.Sync files.

This helps a lot in increasing productivity,don't you think ? ;)

Peace.