Freeze rows or columns in MS Excel or Office 365 Sheets

 Freeze rows or columns

Sometimes you want to freeze certain rows or columns or even an area in Excel sheet that you do not want to move while scrolling the sheet on left, right, up or down. Here is what you need to do - The Freeze Pane feature!

Freeze the first column

• Select View > Freeze Panes > Freeze First Column.

            The faint line that appears between Column A and B shows that the first column is frozen.

Freeze the first two columns

1. Select the third column.

2. Select View > Freeze Panes > Freeze Panes.

Freeze columns and rows

1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.

2. Select View > Freeze Panes > Freeze Panes.

Cannot Start Microsoft Outlook. Invalid XML, the View Cannot be Loaded

One way your Outlook blocks you from accessing emails is when it Cannot Start Microsoft Outlook. Invalid XML, the View Cannot be Loaded" Error Message. The cause is also simple and more is its fix.

Follow the following steps below to clear and regenerate your Navigation Pane if you receive an error message that says "Cannot start Microsoft Outlook. Cannot open the Outlook window. Invalid XML, the view cannot be loaded."

Problem:

When opening Microsoft Outlook Windows client, you receive the following error:

"Cannot start Microsoft Outlook. Cannot open the Outlook window. Invalid XML, the view cannot be loaded."

Opening Outlook in SAFE mode does not help, nor can this problem fixed by running repair or even by re-installing Outlook.

Fix:
To fix this error, run the Outlook.exe  /ResetNavPane command:

Where to run:
Hold the Windows key and the R key at the same time.
The Run command window will open. Copy Outlook.exe  /ResetNavPane into the text field.
Click OK to run the command.

What happens:
Running this command clears and regenerates the Navigation Pane for the current profile, removing all shortcuts and favorite folders from the Navigation Pane.


Its time for a cheers ;)
Enjoy.

Difference between Nuget and Chocolatey

NuGet is designed to allow you to easily add code libraries to your project. Things like JSON.NET, Entity Framework, etc.

Chocolatey is actually built on top of the NuGet package system, but it is designed to fill a different need. Chocolatey wraps up applications and other executables and makes it easy to install them on your computer. For example, tools like Git and Notepad++, etc. can be easily installed with a command like: cinst git.

To know more about chocolate and how to install it please refer my earlier blog post on W3LC : http://www.w3lc.com/2017/11/what-is-chocolatey-and-how-to-install.html

https://chocolatey.org/packages has a list of all the applications that can be installed.

If you have an open source project which is a library that is to be used in other developers' projects, then you should submit it to NuGet.

If it is an application that users would normally install, then create a Chocolatey package that users can easily install and update from the command line.

Details of different Package manager tools and where does Chocolate fits in:

OneGet has been renamed to Package management. It's core provides you with discovery and installation/uninstallation of various packages. OneGet is often referred to as a "package manager manager".

OneGet is a part of WMF 5 installation. Think of this as the "central concept" in the big picture. Now let's talk about packages.

Packages are fetched through package providers. E.g. PowerShellGet is one package provider for OneGet. Powershell gallery is a package source of of PowershellGet (PSGet). A provider can have multiple sources where it can search for it's packages.

E.g for the nuget-package provider; you can easily add the sources to the public nuget gallery and register your own e.g. myget source so it can be used when searching for packages.

Chocolatey is just another example of a package provider. Earlier it had to be installed and was a seperate module with it's own logic. The new Chocolatey provider conforms to the new framework of installing / managing packages.

So on a more conceptual level; a package provider itself contains information on how to install and search it's sources (sources can be registered/unregistered for each and every provider); whilst OneGet (Package management, package manager manager) works on the level above, managing package providers and interfacing this all for you.

OneGet glues it all together; while the providers itself knows how to handle packages based on it's registered sources.

Hope this explains it on the conceptual level.

See also this nice blogpost here explaining a few things more in detail:https://blogs.technet.microsoft.com/packagemanagement/2015/05/05/10-things-about-oneget-that-are-completely-different-than-you-think/

If you want to play around with package providers and sources :

 Get-PackageProvider # -Shows package providers installed on your machine)
 Find-PackageProvider # -Find online package providers you can pull down and install)
 Get-PackageSource # -List all package sources, with it's provider name)
 Register-PackageSource # -Register new package source for a provider)

Strings tool from Sysinternals: String Obfuscation Testing to find Hardcoded Strings in source code

It was in 1996, that Sysinternals website was Created. Mark Russinovich and Bryce Cogswell hosted their advanced system utilities and technical information. The Sysinternals utilities help you manage, troubleshoot and diagnose your Windows systems and applications.

One of these Tools is Strings. Current version is v2.5

At times, DLL, executable, .lib and object files have embedded UNICODE/ Ascii strings that you cannot easily see with a standard ASCII strings or grep programs. Strings is a utility that scans the file you pass it. By default, it searches for strings of length of 3 or more. Wonderful part is that it works on nearly all flavors of Windows including Win 95!

This became such a hit that even Microsoft has given great interest in this project. And, the result is that today you can download this utility directly from Microsoft Website. Yes!! MS holds it now!!
Download from: http://technet.microsoft.com/en-us/sysinternals/bb897439.aspx

Using Strings program:-
1. Open a command prompt
2. Run strings
3. There are multiple options that are described as below:-

usage: strings [-a] [-f offset] [-b bytes] [-n length] [-o] [-q] [-s] [-u]
Strings takes wild-card expressions for file names, and additional command line parameters are defined as follows:
-o Print offset (not of much use)
-n This is the minimum string length (default is 3)
-q Quiet mode
-s Recursive traversal of subdirectories
-a ASCIIonly search [default is Unicode and Ascii]
-b how many Bytes in file to scan
-f File offset from which to start scanning.
-u Unicode-only search (Unicode and Ascii is default)
Happy catching your hardcoded strings. Make your product more secure.

GeoBing by Anwar Faiz: First Facebook App using Bing Maps

I have developed a new Facebook Application and wanted to post something about that.

Name of the Facebook App: GeoBing

Description: Use the GeoBing App to share your location on Facebook using Microsoft's Latest Bing Maps. Your Profile would get updated with your current location and map.

Importance: GeoBing Facebook Application is the world's first innovative way to share your Geographical Location over Facebook using Bing Maps. You can even do it from your Laptop and Desktop Browsers.!!

GeoBing FaceBook Link: http://apps.facebook.com/geobing/?ref=ts

Steps to use:

Step 1: Click this button Show map. [You need to click this]

Step 2: When prompted, allow your location to be shared to see Geolocation in action

Step 3: When you see your Location information on the Map below, Click 'Post to Facebook' button on the bottom.

Effect: Your geographical location would be posted over your Facebook profile page.

Help promoting this App. This was designed in curiosity to use Bing Maps. And I am happy and glad to let you all know, GeoBing is the first Facebbok Application that uses Microsoft Bing Maps to post your Geographical location. This works from your desktop, laptops, handheld devises, Samsung Galaxy S2, Iphone, Ipads etc.

Love u all.
Keep clicking advertisements. Keep reading more original contents.
-Mohd Anwar Jamal Faiz