Concatenate a group of cells in Excel

If you want to concatenate a group of cells in excel in a column into a single cell, we can use multiple options like writing a macro and then calling the function whenever you need it. This option is very good, if you are doing the same process multiple time and then the structure of [...]

Read more

INDIRECT inside a SUMPRODUCT

Using INDIRECT function is one of the very useful feature in EXCEL. Used heavily whenever we need to create a summary for our report. But using it inside a SUMPRODUCT function is bit tricky. The formula is =SUMPRODUCT(INDIRECT(B6&”!C6:C21″),Rates!C6:C21) Here i have the name of the sheet (For eg: PeopleDetails) in the B6. Then i need [...]

Read more
Speech in Powershell – Continue

Speech in Powershell – Continue

In my previous post i had shown, how to save the text in an audio format and then listen. But if we just need to listen without saving the audio, then it is much simpler and very easy. So here i have written the script to convert the text to audio without saving it to [...]

Read more
Speech in Powershell

Speech in Powershell

Powershell gives us lot of cool things, this is one such feature. Speech in Powershell. It uses COM Objects to make it work. Turn on your speakers!!!! This code creates an audio file from a text file. You can make powershell to read you a book, then make powershell to create an audio file and [...]

Read more

Removing Backup folders – Solution 1

There are lot of different ways we need to delete backups. One way is to delete backups after certain number of days, other will be to delete all except last modified. Here I have written a script which will remove all the backup folders EXCEPT the last (or any number of last) modified folder from [...]

Read more

Bangalore PowerShell User Group Inaugural meet

For all Powershell Users , there is going to be a Powershell User Group Meet in Bangalore . I am sure it will be great. Make use of it. https://psbug-july282012.eventbrite.com/ Have fun.

Read more
Get-Webapplication

Name of Web Applications using Powershell

Powershell is the one of the most powerful tool for Administrators. Any information can be retrieved from the IIS when ever they want. Here i have written a script to get all the Name of the Web Applications that are there in the IIS. First thing import the web administrator module so that you can [...]

Read more

Windows PowerShell 3.0 and Server Manager Quick Reference Guides

There are few references and cheat sheet for Powershell 3.0 . You can download form the link given below. http://www.microsoft.com/en-us/download/details.aspx?id=30002 All details are given in the website.

Read more

Get Services Using Powershell

Its very easy to get all the services in our system. Just use Get-Service But if you want to print all the names of the running services alone and then print it into a file, use the below code. You can easily change the script according to your requirements. Get-Service | Where-Object {$_.Status -eq ”Running”} | foreach-object {$_.Name} | Out-File ”C:\serv.txt” Try it out….

Read more