Solution : How to open excel sheet in new window

Option 1

In Excel 2003, go to Tools -> Options -> General tab.

Make sure the option, ‘Ignore other applications’ is checked. Now all the Excel files will be opened as separate instance and you can move the Excel files individually across the monitors.

In Excel 2007, Click the Office button -> Excel Options -> Advanced.

Under General, check ‘Ignore other applications that use Dynamic Data Exchange’.

Open the file by double click, and now it would open in new instance.

Option 2:

use Excel Instance Launcher

Solution : restore iphone 4 error 1013 and 1611

Ref: http://discussions.apple.com/thread.jspa?threadID=2655717&tstart=0 , Peru

Remove the line that has gs.apple.com completely and save host file on your host system.


Please use the following the instructions depending on your system

On Mac:

* Open Finder
* Hold down COMMAND + SHIFT keys and press 'G'
* Enter "/private/etc/" in the field and press "Go"
* Find "hosts" file in the directory
* Drag the file to your desktop
* Open it in text editor
* Remove the line that has gs.apple.com entirely or put a # at the beginning of it to comment it out
* Save the file
* Drag it back to the /private/etc/ folder.
* You'd need to enter your username and password to authenticate the move

On Windows:

• Locate the hosts file in one of the following directories:

Windows 95/98/Me c:\windows\hosts
Windows NT/2000/XP Pro c:\winnt\system32\drivers\etc\hosts
Windows XP, Vista, 7 c:\windows\system32\drivers\etc\hosts 

• Right click and click on "Open With..." and then click on "Notepad" on the list.

* Remove the line that has gs.apple.com completely and save the file.

restart your itunes.

This should work fine but you will lose all music, photos, videos and books :S

[: missing `]' +bash +shell scripts

 "=" sign requires a blank in front of it and after it. Otherwise, the bash only sees "something" within the brackets, and that is true (0), while "nothing" is false (1):

ex.

[ 5 = 6]

solution 

[ 5 = 6 ] 

Tutorials:

http://wiki.linuxquestions.org/wiki/Bash_tips

http://www.tldp.org/LDP/abs/html/

https://wiki.archlinux.org/index.php/Color_Bash_Prompt 

Solution: rpmbuild: command not found

yum  install  rpm-build

Solution: merge two files / append two files in Linux

Code:

cat file1 file2 .. fileN  > mergedfile

Note the '>' in the command: it points that the target file follows, don't forget to put it there.

Advance:
 
If you accept that entries in the resulting file are sorted, you can use uniq to remove duplicates.

Code:

cat file1 file2 | sort | uniq > mergedfile

Solution : raise TypeError("bufsize must be an integer")

Error : subprocess.call(['vim'],['/home/patelm/.bashrc'])

Solution: subprocess.call(['vim','/home/patelm/.bashrc'])

Whenever you're running subprocess.call and you see this
error, say to yourself: "Have I passed the command line
as one parameter in a list; or have I passed it as a series
of parameters?"

diff rcs file

Code:

rcsdiff -r1.1 -r1.2 -u file

here we are diffing rev 1.2 agains 1.1


If you want to colour the output you can use the idiff script

Code:

rcsdiff -r1.1 -r1.2 -u file | ./idiff

How to view content of RPM package

use following switch

--filesbypkg
    List all the files in each selected package.

rpm -q -filesbypkg -p filename.rpm

Word 2007: Password Protect Your Document File

1. Click the Microsoft Office Button, and then click Save As.
2. Click Tools, and then click General Options.
3. You can type a password in Password to open or Password to modify.
4. Click OK.
5. When prompted, retype your passwords to confirm them, and click OK.
6. Click Save.

ref:- http://www.technipages.com/word-2007-password-protect-your-document-file.html

Solved : Finding computer name using IP

Windows:

nbtstat -a ipaddress

Linux:

nmblookup -A  ipaddress