Search This Blog

Wednesday, May 11, 2011

[Solved] Macros Not Working Microsoft Office Excel 2010

[Solved] Macros Not Working Microsoft Office Excel 2010

Macros have been disabled in Microsoft Office 2010 , this has been done in order to keep your system away from all the vulnerable code that are present in the macros. This macros security feature has been added keeping in mind about the history of the macros viruses, but sometimes we really really need them to get our work done. In this tutorial i will be telling you a very simple way in order to enable your macros when you require them.

The macros are generally used in order to communicate with excel, as VBE uses them to do so. In this tutorial i will not be using any external tool to enable the macros but i will alter some of the default settings in the Microsoft Office which will enable the macros and then you will be able to use it. You will just have to follow the steps mentioned below and then you can enable the macros. The steps narrated below are for the Excel but they are quite similar to the steps to be used in Word.

  1. The excel window will look similar to the one shown below in the snapshot. You see can a green colored tab named as File in the menu bar. Click that tab.
    8-14-2010 2-26-29 PM

  2. You can see the option under File, as shown below in the snapshot. At the bottom of those options you can see two sub-options named as Options and exit, which are written in small font as compared to the others written above it. Click the ‘Option’ tab
    8-14-2010 2-27-07 PM

  3. You will see another window as shown in the snapshot below, where again you can see some of the options enlisted on the left side. Now, on that list click the Trust Center option.
    8-14-2010 2-27-22 PM

  4. You can see the that an option has been highlighted with the green colored circle, which is supposed to be clicked. On clicking that option you will another window which will be similar to the one shown below in snapshot. Now to enable the macros, click the option circled in green in the application window. Though doing this has not been recommended but you can do it and then the macros will be enabled.
    8-14-2010 2-28-37 PM

I hope that this tutorial has met its requirements and it will help you to solve your problem. Please try to use this and leave any comment if you have a better solution to this problem. We will be glad to publish it, if we found it genuine.

Error starting Outlook: "Cannot start Microsoft Office Outlook. Cannot open the Outlook window."

Error starting Outlook: "Cannot start Microsoft Office Outlook. Cannot open the Outlook window."

This problem can occur when file that maintains the Navigation Pane settings becomes corrupted. This file is called profilename.xml, where profilename is the name of your Outlook profile. This file is stored in the following folder:

  • Windows XP

    C:\Documents and Settings\username\Application Data\Microsoft\Outlook
  • Windows Vista, Windows 7

    C:\Users\username\AppData\Roaming\Microsoft\Outlook

A good indication this file is corrupted is when the file size is 0 KB.


Let me fix it myself

To resolve this problem, use the following steps.

  1. On the Start menu click Run.
  2. In the Run dialog box, type the following command:

    Outlook.exe /resetnavpane

    Note:
    There is a space between "Outlook.exe" and "/resetnavpane"
  3. Click OK.

Note If you are using Windows Vista or Windows 7, you may not see Run on the Start menu. In this situation, use the following steps to locate the Run option.

  1. On the Start menu click All Programs.
  2. Click Accessories.
  3. Click Run.

Add Background Watermark To Word Documents Easily

Add Background Watermark To Word Documents EasilyEver since I have started using Microsoft Office 2010, I find it very easy to locate stuff on the menu and do simple but useful operations with help of intuitive iconography on the menus. In this short tutorial on Microsoft Office Word which will help you put any copyright message, confidentiality message or other watermark which may be necessary for your MS Office Word document.

Microsoft word 2010

Adding a watermark to a document is very simple, just follow these three easy steps to add any text or image watermark to your word documents.

Adding Watermark To MS Word Documents

Step 1: Go to “Page Layout” and click “Watermark” Option

add-watermark-to-word-document1

Step 2: Select the standard watermark layouts or click on “Custom Watermark” if you want your own image or text watermark on the document.

add-watermark-to-word-document2

Step 3: Just select an image or text with style of watermark on this “Printer Watermark” window and click OK. This is it, its done !

add-watermark-to-word-document.3png

This is how a document background looks after applying watermark to it.

add-watermark-to-word-document

Hope you find these steps easy to follow. Do share this tutorial with your friends who work on MS Word, this might be helpful to them as well. Please share your suggestions and thoughts with us via comments below.

Delete Unused Windows Files Automatically

Delete Unused Windows Files AutomaticallyWe are in a habit of saving the documents, videos or any other type of files what we think might be useful later. But soon we realize that there is a large collection of extra files and folders which might not be used any more. These files decrease the efficient use of the available memory of your computer. But you would never prefer to remove data manually. I would like to review a tool Cyber-D’s Autodelete to solve such problems automatically. As the name suggests, it is used to delete the files and folders automatically.

sshot-2

The above snapshot shows the Cyber-D’s Autodelete tool. It is a small freeware of 1839 kb only. You can download and install it very fast. The installation will create two icons on your desktop: one to configure and another to run the tool. Now, what you need to do is configure the tool for the folders where you used to store the bulk which has to be deleted after some time. So, select the folders in which the files are to be deleted. The useless files will be deleted after the specified time according to the criteria selected. There are certain options available which can help you to refine the deletion process. They are:

Setting Filters:

There can be two types of filters:

  1. The files or folders you would never like to delete.
  2. The only files or folders to be deleted as per the criteria defined by the user.

You have to add the filter and edit it as per the requirement. The help option shows the various formats in which the filters can be applied.

Deletion Criteria:

  • Specify the number of days after which the deletion is to take place.
  • Select whether the days are to be counted according to the last date- it was modified, created, both or accessed.

Other Options:

You can select the process to be carried out with the deleted files like move to trash, secure them or move to a particular folder. You can also select what is to be done with the subfolders and the empty subfolders.

You can go through the video shown below to understand the working of this tool.

You can select the automatic deletion whenever the Windows start . But if required you can also run it manually. You can keep the log of deleted filed if you want. The tool is designed to delete the files permanently from trash after 90 days by default though it can be changed. You can remove the folder from autodelete whenever you want.

After the long list of useful options available, you would surely like to use this software.

This software will be compatible with all the older versions of windows as it has been checked on Windows 7 32-bit operating system.

Download Cyber-D’Autodelete

Add Tabs In Word 2010 To Handle Multiple Documents

Add Tabs In Word 2010 To Handle Multiple Documents

There are times when you need to open multiple documents in Microsoft Office Word 2010, you might have noticed each time you open a document then it opens a new instance of word, it becomes difficult to switch in between these multiple word windows, however word 2010 has a feature to quick switch in between different documents opened.

windows-live-writer

We just found a cool addon for word 2010 which will add tabs in word, just like the browser interfaces like Google chrome or Firefox have. These tabs will represent various word documents opened in in the same word window and you can easily switch across them through these easy to click tabs.

wordaddintabs

Word Addin Tabs realizes most of the functions of “IE Tabs” in Microsoft office 2007 or Microsoft office 2010 Word. If you want to close the “Word Addin Tabs”, just click the “Add-ins” tab in the Word Ribbon, choose the DocTabs group, click the “Tabs” button, and then the “Word Addin Tabs” function will be disabled. By using the Word Addin Tabs, you can not only click “X” to close the document, but also right click the related tab of the document, and close it through the pull-down menu.

Download Word Add-in Tabs For Word 2010 or 2007

Note: We have tested the above addon with word 2010 and 2007, but we are not sure whether this will work more earlier versions of MS Office word

Clone Computer, Reset Windows Password, Clean Up Disks, Run Diagnostic, Virus Scans, And Much More With Trinity Rescue Disk

Clone Computer, Reset Windows Password, Clean Up Disks, Run Diagnostic, Virus Scans, And Much More With Trinity Rescue Disk

Have you ever lost your data in a computer failure ? Any kind of hardware failure, software failure, Windows crash or something like that ? If yes, you might like this Rescue Kit which I am going to review in this article. If No, then also this Rescue Kit may come in handy for managing any computer related failure.

Most of the computer failures occur because of Virus problems or Windows crash due to some problem, second most major cause is failure of an old hard disk drive. In this post, I am reviewing Trinity Rescue Disk which is a small and power-packed rescue disk which does a lot of wonderful tasks which can save you a lot of trouble and data losses.

Some of the major features of the Trinity Rescue Kit Include :

  • Easily reset windows passwords with the improved winpass tool
  • 5 different virus scan products integrated in a single uniform command line with online update capability
  • Full ntfs write support thanks to ntfs3g
  • Winclean, a utility that cleans up all sorts of unnecessary temporary files on your computer.
  • Clone computers over the network via multicast.
  • Contributed backup utility called "pi", to automate local machine backups
  • Easy script to find and mount all local filesystems
  • Run a SSH server
  • Recovery and undeletion of files with utilities and procedures
  • Recovery of lost partitions
  • Evacuation of dying disks
  • Full read/write and rpm support
  • 2 rootkit detection utilities

You can very easily download the ISO image ( download link at the end) of the tool and boot the infected or crashed computer using this ISO file.

When you boot the computer using the Trinity Rescue Kit CD or USB, the boot screen looks something like this :

trinity-boot-sequence

On successful boot you will see 22 different options ranging from Windows Password reset, Virus scanning, Memory and hard disk diagnostics to Disk cleaning. Below you can see the options.

Trinity-boot-options Trinity-boot-options-continued

On Trinity Rescue Kit Easy Menu you can use options which are menu driven and can be controlled with keyboard using arrow keys.

trinity rescue disk easy menu interface

One of the most useful options of this Rescue Kit is “Windows Password Resetting” which uses winpass utility to reset Windows Password.

trinity windows password restting option

The Sub-Menu which appears when you access the Windows Password Resetting Option includes interactive winpass, winpass with command line etc.

trinity windows password restting options detailed

Below is the virus scanning menu which gives you options to scan your computer with

  • Clean AV Anti-Virus
  • F-Port Anti-Virus
  • BitDefender Anti-Virus
  • Vexira Anti-Virus
  • Avast Anti-Virus

trinity rescue disk virus scanning options

You can also create an image of your computer to to some other PC with replication option, this maybe very useful for backing up entire computer image.

trinity computer replication options

The replication sub-menu gives you option to use the present computer as server or client for replication purpose.

trinity rescue disk clonning detailed menu

Trinity also provides remote support for which you need to call them first and then use this option.

trinity remote support options

Download Trinity Rescue Kit

Refer this tutorial to make USB bootable with downloaded image file - Make Pen Drive Bootable

Wednesday, April 27, 2011

Job sites in india list

in.jobstreet.com
india.recruit.net
job.rediff.com
jobs.jobsagar.com
jobs.oneindia.in
www.123oye.com
www.allindiajobs.net
www.alltimejobs.com
www.bestindiansites.combest-job-sites-in-india.html
www.bestjobsindia.in
www.bharatcareers.com
www.bharathcontractjobs.com
www.bigmouth.co.in
www.bixee.com
www.bpoavenues.com
www.careerage.com
www.careerbuilder.co.in
www.careerindia.com
www.careerjet.co.in
www.careerkhazana.com
www.careermosaicindia.com
www.citehr.com
www.ckickjobs.com
www.clickjobs.com
www.constructionrecruitments.com
www.coolavenues.com
www.devbistro.com
www.devseeker.in
www.educationaljobsinindia.com
www.efinancialcareers.co.uk
www.firstsalary.com
www.fresherjobs4u.com
www.freshershome.com
www.freshersplanet.co.cc
www.freshersworld.com
www.fundoodatajobs.com
www.goldenjobs.com
www.gotachance.com
www.hirefire.co.in
www.iconjob.com
www.indeed.co.in
www.india.jobs.com
www.indiajobexpress.com
www.indianjobsite.com
www.indianjobsonline.com
www.indiasjobs.com
www.itplacementsindia.com
www.itsmyascent.com
www.jobconsultancy.com
www.jobgenes.com
www.jobhub.in
www.jobmaya.com
www.jobmixi.com
www.jobokplease.com
www.jobs4testing.com
www.jobsahead.com
www.jobsahead.net
www.jobs-bank.com
www.jobs-bank.comindex.php
www.jobsforindia.net
www.jobships.com
www.jobsindia.com
www.jobsiteindia.com
www.jobsitesindia.com
www.jobsomega.com
www.jobsontemp.com
www.jobstreet.com
www.jobsviewer.com
www.kbsconsultants.com
www.keralajobs.com
www.mantrajobs.com
www.monsterindia.com
www.naukri.com
www.naukri2000.com
www.naukri24x7.com
www.naukriguru.com
www.oneclickjob.com
www.onlineresumebank.com
www.placementindia.com
www.ritejobs.com
www.shine.com
www.splashindiajobs.com
www.telecomitjobs.com
www.therecruiterslounge.com
www.timesjobs.com
www.trail2hire.com
www.usjobcareer.com
www.vfreshers.com
www.visapro.com
www.vrminfotech.comsolutions/job-portals.htm
www.yuvajobs.com

Wednesday, May 27, 2009

Unlock Password Protected PDF & Excel Files Online The Easiest Way For Free

Unlock Password Protected PDF & Excel Files Online The Easiest Way For Free

Unlock PDF PasswordPDF authors often restrict their files using PDF security features preventing users from copying, editing or printing the contents, and like every other protection this can also be easily bypassed, there exist several methods to crack or unlock PDF files, but if you are looking for a simple and fast way to just bypass the copying & printing restrictions of the PDF file Ensode online PDF Unlock Utility will be the best option, You just need to upload the file and the unlocked version of the PDF without printing or copying/pasting restrictions will be displayed in a new browser window in your default PDF application, Similarly you can use "Ensode Free Excel Spreadsheet Unlock Online Utility" to unlock Microsoft Excel spreadsheet passwords.

Online Unlocker


http://www.ensode.net/xls-crack.jsf
http://www.ensode.net/pdf-crack.jsf

Friday, March 27, 2009

How to Install SQL Server 2005

How to Install SQL Server 2005 - A Quick Guide

Purpose: To describe how to perform a basic installation of SQL Server 2005.

Version Information: Although this document addresses SQL Server 2005 Developer Edition, the instructions are very similar or the same for other editions of SQL Server 2005.

Important Notes: Before installing SQL Server 2005, SQL Server 2000 databases should be backed up (if they are required), and the SQL Server 2000 software should be completely un-installed through the Control Panel, UNLESS there is a technical requirement for it to exist on the same machine.

Although SQL Server 2000 and 2005 can exist side by side on the same machine, they have to be installed as separate named instances. This document does not attempt to address the details of SQL Server named instances – if in doubt, consult the DBA for the project for which the installation is being performed.

Should a user require SQL Server 2000 AFTER SQL Server 2005 has been installed, it can be installed as a separate named instance, however a check should be made to ensure that any critical applications that require SQL Server 2000 are capable of supporting named instances – not all are.

1. Insert the DVD into the DVD drive and double-click on the icon:


2. The installation screen should appear:

For most installations, if installing on standard 32 bit Windows XP Professional, click on the x86-based operating systems option.3. Click on Server components, tools, Books online and samples:


4. Read the terms and conditions of the license agreement and click the check box to accept them:


Then click Next.5. The Installing Prerequisites screen appears:

Click on the Install button and wait whilst the system components are configured. This may take 10-20 seconds.6. Once the prerequisites are installed, click on the Next:

7. Wait for a few seconds for the following screen to appear, and then click on Next:

8. The System Configuration Check screen appears:

If the configuration check completes successfully (Success appears in the top panel, all ticks in the Details panel), click on Next.9. Fill in the Registration Information details:

Click on Next.10. Select the components to install:

Note that the components selected in the screen shot above are the most common components that will be needed for most developers and development DBAs. However, if another component such as Analysis Services is needed, it can be added easily afterwards by re-inserting the installation DVD and re-running the setup program.

Click on the Advanced button to open up further options.

11. The advanced Features Selection screen opens:

IMPORTANT NOTE
As a general rule it is not necessary to change the default installation path or the Developer Edition installation, unless your organization has a standard which is different. If in doubt, check an existing PC or server at your site.

Click on Next.

12. Select the Default instance:

IMPORTANT NOTE
If the Default instance radio button is disabled, this probably means that there is another, default instance of SQL Server 2000 or SQL Server 2005 already installed on this machine. In this case, consult the DBA for the project as it may not be necessary or desirable to re-install the database components.

Click on Next.

13. Select the radio button "Use the built-in System account":

The first step will change the Windows account under which the SQL Server service executes to the Local System account. In a production environment or certain development environments, it may be desirable to change this to a domain user account, but this is not usually necessary for local developer installations. Note that the service account settings can be changed through the Services applet in the Control Panel at any point after installation, however SQL Server will require re-starting in order for these changes to take effect.

Click on Next.

14. Change Authentication Mode to Mixed Mode and set a password for the sa logon. The user’s NT logon name could be used as an initial password, but note that whatever is used, it should NOT be the same for each machine as the sa account gives sysadmin privileges to any user who uses it:

Click on Next.15. Keep the default collation settings, UNLESS the DBA for the project specifies that they should be changed. Be aware that certain applications require non-default settings:

Click on Next.16. Select Error Reporting and Usage options – it does not matter what these are set to, as they are completely at your discretion:

Click on Next.17. The pre-installation screen will now appear:

Click on Install.18. The Setup Progress screen will appear, informing you of installation progress:

This step usually takes 10-30 minutes, but requires no user intervention - so now's a good time to take a break and make some coffee.19. The Setup steps have completed:

Click on Next.20. The "Completing Microsoft SQL Server 2005 Setup" screen will now appear:

If you only want the database server to be accessible from the machine on which it is installed, click on Finish. SQL Server 2005 installation is now complete.

However, if you wish the database server to be accessible from other machines, click on the Surface Area Configuration tool link.

21. The "Help Protect Your SQL Server" screen will appear:

Click on the Surface Area Configuration for Services and Connections link.22. The SQL Server 2005 Surface Area Configuration screen will appear:

Click on the Remote Connections node in the left hand tree pane, then click on Local and remote connections. By default, TCP/IP only is selected and is usually sufficient in most development environments, but if you suspect that you may need SQL Server 2005 to host legacy applications which require support for the named pipes SQL Server communication protocol, click on “Using TCP/IP and Named Pipes”. If in doubt, consult the DBA for the project.

In addition, if you wish this installation of SQL Server to automatically announce itself on the network to automatic database server directory queries, click on the SQL Server Browser Service, set the Startup type to ‘Automatic”, click on “Apply”, then click on the Start button.

Click on OK, and then close the “Help Protect Your SQL Server” screen.
Finally, click on the Finish button on the “Completing Microsoft SQL Server 2005 Setup” screen.

SQL Server 2005 setup is now complete.