Tuesday, February 23, 2016

My Office program did not open a recovered file

Office program did not open a recovered file

Symptoms

You turned on the AutoRecover feature before the Microsoft Office program closed abnormally. However, when you start the program again, it doesn't open the recovered file.
Notes
  • The information in this topic can help you if you turned on the AutoRecover or AutoSave feature. Also, you should make sure that the save interval is set to ensure that your work is saved frequently enough. For more information, see Automatically save and recover Office files.
  • In general, when you restart the program, the program re-opens the files that were automatically saved. You should use the following information only if the program does not open a file that you think was automatically saved.

Resolution

When you restart a Microsoft Office program after a power failure or other problem, the program automatically opens any recovered files. If for some reason the recovery file doesn't open, you can try to open it yourself.

Manually open an automatically saved file

Which 2007 Microsoft Office system program are you using?

Excel 
PowerPoint 
Publisher 
Visio 
Word

Excel

  1. Click the Microsoft Office Button Office button image, and then click Open.
  2. In the Open dialog box, type the path and file mask below into the address bar at the top of the window to display a list of the automatically saved files. The path and file mask for Excel depend on the version of Microsoft Windows you are running:
    • Windows Vista
      %userprofile%\AppData\Roaming\Microsoft\Excel\
    • Microsoft Windows Server 2003 or Microsoft Windows XP
      %userprofile%\Application Data\Microsoft\Excel\*.xlsb
  3. Click the name of the file that you want to recover, and then click Open. If you are not sure which file you need to open, do the following:
    • The automatically saved files are named by using the following convention: Original file name (version Version number). For example, if your original file is named Trucks, the automatically saved file name should be Trucks (version 1).
  4. Optionally, you can modify the file list in the Open dialog box to make it easier to browse through the files to find the right one:
    • Click the arrow next to the Views Button image button, and then click Details.
    • Click the column header to sort the list by Name, Size, Type, or Date Modified. Click the column header again to sort the list in the opposite order. For example, click Date Modified once or twice so that the list of files is sorted with the most recently modified files at the top of the list.
  5. Continue to open files until you find the one you are looking for. After you find the file, click Save Button image.
 

PowerPoint

  1. Click the Microsoft Office Button Office button image, and then click Open.
  2. In the Open dialog box, type the path and file mask below into the address bar at the top of the window to display a list of the automatically saved files:
    %temp%\ppt*.tmp
  3. Click the name of the file that you want to recover, and then click Open. If you are not sure which file you need to open, do the following:
    • The automatically saved files are not named in a descriptive way. See the next step for information about how to use the Open dialog box to help you find the right file.
  4. Optionally, you can modify the file list in the Open dialog box to make it easier to browse through the files to find the right one:
    • Click the arrow next to the Views Button image button, and then click Details.
    • Click the column header to sort the list by Name, Size, Type, or Date Modified. Click the column header again to sort the list in the opposite order. For example, click Date Modified once or twice so that the list of files is sorted with the most recently modified files at the top of the list.
  5. Continue to open files until you find the one you are looking for. After you find the file, click Save Button image.
 

Publisher

  1. On the Standard toolbar, click Open Button image.
  2. In the Open dialog box, type the path and file mask below into the address bar at the top of the window to display a list of the automatically saved files:
    %temp%\pub*.tmp
  3. Click the name of the file that you want to recover, and then click Open. If you are not sure which file you need to open, do the following:
    • The automatically saved files are not named in a descriptive way. See the next step for information about how to use the Open dialog box to help you find the right file.
  4. Optionally, you can modify the file list in the Open dialog box to make it easier to browse through the files to find the right one:
    • Click the arrow next to the Views Button image button, and then click Details.
    • Click the column header to sort the list by Name, Size, Type, or Date Modified. Click the column header again to sort the list in the opposite order. For example, click Date Modified once or twice so that the list of files is sorted with the most recently modified files at the top of the list.
  5. Continue to open files until you find the one you are looking for. After you find the file, click Save Button image.
 

Visio

  1. On the Standard toolbar, click Open Button image.
  2. In the Open dialog box, type the path and file mask below into the address bar at the top of the window to display a list of the automatically saved files:
    %temp%\*.vsd
  3. Click the name of the file that you want to recover, and then click Open. If you are not sure which file you need to open, do the following:
    • The automatically saved files are not named in a descriptive way. See the next step for information about how to use the Open dialog box to help you find the right file.
  4. Optionally, you can modify the file list in the Open dialog box to make it easier to browse through the files to find the right one:
    • Click the arrow next to the Views Button image button, and then click Details.
    • Click the column header to sort the list by Name, Size, Type, or Date Modified. Click the column header again to sort the list in the opposite order. For example, click Date Modified once or twice so that the list of files is sorted with the most recently modified files at the top of the list.
  5. Continue to open files until you find the one you are looking for. After you find the file, click Save Button image.
 

Word

  1. Click the Microsoft Office Button Office button image, and then click Open.
  2. In the Open dialog box, type the path and file mask below into the address bar at the top of the window to display a list of the automatically saved files. The path and file mask for Word depend on the version of Windows you are running:
    • Windows Vista
      %userprofile%\AppData\Roaming\Microsoft\Word\
    • Microsoft Windows Server 2003 or Microsoft Windows XP
      %userprofile%\Application Data\Microsoft\Word\*.asd
  3. Click the name of the file that you want to recover, and then click Open. If you are not sure which file you need to open, do the following:
    • The automatically saved files are named by using the following convention: Auto Recovery save of Original file name. For example, if your original file is named Trucks, the automatically saved file name should be Auto Recovery save of Trucks.
  4. Optionally, you can modify the file list in the Open dialog box to make it easier to browse through the files to find the right one:
    • Click the arrow next to the Views Button image button, and then click Details.
    • Click the column header to sort the list by Name, Size, Type, or Date Modified. Click the column header again to sort the list in the opposite order. For example, click Date Modified once or twice so that the list of files is sorted with the most recently modified files at the top of the list.
  5. Continue to open files until you find the one you are looking for. After you find the file, click Save Button image.
 

Excel

  1. Click the Microsoft Office Button Office button image, and then click Open.
  2. In the Open dialog box, type the path and file mask below into the address bar at the top of the window to display a list of the automatically saved files. The path and file mask for Excel depend on the version of Microsoft Windows you are running:
    • Windows Vista
      %userprofile%\AppData\Roaming\Microsoft\Excel\
    • Microsoft Windows Server 2003 or Microsoft Windows XP
      %userprofile%\Application Data\Microsoft\Excel\*.xlsb
  3. Click the name of the file that you want to recover, and then click Open. If you are not sure which file you need to open, do the following:
    • The automatically saved files are named by using the following convention: Original file name (version Version number). For example, if your original file is named Trucks, the automatically saved file name should be Trucks (version 1).
  4. Optionally, you can modify the file list in the Open dialog box to make it easier to browse through the files to find the right one:
    • Click the arrow next to the Views Button image button, and then click Details.
    • Click the column header to sort the list by Name, Size, Type, or Date Modified. Click the column header again to sort the list in the opposite order. For example, click Date Modified once or twice so that the list of files is sorted with the most recently modified files at the top of the list.
  5. Continue to open files until you find the one you are looking for. After you find the file, click Save Button image.


Source 

Friday, February 5, 2016

How to Check Technology adoption of any website?

Now a days most of the businesses are on the Internet, so but obvious your competitors will also be there. Another term of working on Internet is working using technology and Technology field itself a very Vast field and to beat your competitor you must aware what kind of technology is used by your competitor and then only you can beat him in your competition. Now the question is how we can find out what kind of technology i.e. widgets, analytics, frameworks, content management systems, advertisers, content delivery networks, web standards and web servers are used by your competitor and which is really hard to find out.

Builtwith.com is a website which help you in finding all these information and even much more than that. what you need to do is: you just need to open the builtwith.com on your web browser and type the website URL of your competitor on the search Bar and just hit enter, all the information appears in few moments.


For more information about Builtwith.com, just click on their About Us section.

Thursday, February 4, 2016

How to make cells Unclickable (Unselectable) in Excel

People who don't like using the "protection/password" technique to protect the locked cells content. Here is the way to protect the locked cells content without using the "protection/password" technique.

Private Sub Workbook_Open()
'Make cells unclickable without password protection
'change to your sheet name
With Worksheets("sheet1")
.Activate
.EnableSelection = xlUnlockedCells
.Protect Contents:=True, UserInterfaceOnly:=True
End With
End Sub