I’ve updated the post through feedback in the comments: Regex compare on strings for Get-Variable is Where-Object -Match. So, the closest parallel to the following bash code: set | grep "Users" is the following Powershell: Get-Variable | Where-Object { $_.Value -Match "Users" } or shortened: gv | ? {$_.Value -Match "Users"} Original Post, with Updates [...]
Archives for Microsoft
Finding the about screen in Word 2007
I had to dig to find this: I used to be able to get the version number via the Help->About… functionality. Pretty standard Windows pattern. I wanted to see if the pushed update of Office 2007 SP2 had been applied this morning, and eventually had to look it up. It is now under the Office [...]
Every time you make an Excel spreadsheet this big, a kitten meets its maker
I’m not really that elitist about non-programmers using applications in an advanced way the programmers could find a better way to do. I’ve never had to port functionality from an Excel spreadsheet that was 2 MB in size prior to data being added–at least not more than once. However, I am a bit disturbed that [...]
Autotext lines in Word (using 2003 here)
Sorry if this is pretty trivial for the true power users of Word… I don’t know if Word 2007 works this way or not, but I’ve discovered a couple additional characters in Word that auto-correct to divider lines. (Other than ‘equals’, ‘minus’, and ‘underscore’). The ‘hash’ divider was of the most interest to me, as [...]
Miscellaneous Excel tricks that I needed today.
How to hide gridlines on an Excel Worksheet. Select a Worksheet.Select Tools->Options…On the [View] tab, un-check Gridlines under the Window Options section. Row and column headers, scroll bars, and sheet tabs are also hideable through this tab. How to Split and Freeze Panes Freeze panes makes very nice title rows (the bottom pane does not [...]
Posts