Last week at the PowerShell Deep Dive in San Diego, I did a short presentation on integrating Microsoft Office applications like Excel and Word with Windows PowerShell. I easily could have spoken much longer and probably tried to cram too much in. I spent a lot of time with my demos. I expect at some point a video of my talk will be posted on the TEC site. In the mean time you can download a PDF of my slide deck and a zip file with all of my demos. Some of the scripts have been revised slightly since my presentation. The scripts are NOT intended for production use. They are demonstration and proof-of-concept scripts. Many of them have hard coded paths for additional files so read them carefully before you try to run. I’ve tried to comment extensively so you can understand what is going on, but this is admittedly a complicated topic. I’m hoping to create some additional videos around these demos, but if you have questions please post a comment.
I’m happy to report that I will be presenting a session at the PowerShell Deep Dive in Frankfurt this October as part of The Experts Conference. The conference in Las Vegas this past April was amazing, intense and the most fun I think I’ve ever had. If you can make it to this show you won’t be disappointed. This is my session:
How-To Turn CLI Tools into PowerShell Tools
PowerShell is everywhere but there are still many command line tools in the IT Pro’s toolbox, In this session we’ll look at how to turn just about any command line based tool into a PowerShell tool so that you can incorporate it into your PowerShell scripts and daily management tasks. The power of objects in the pipeline is amazing and there’s no reason not to include tools like NETSTAT.EXE or NBTSTAT.EXE.
1. The Challenge of CLI Tools
2. Console Text to PowerShell Objects Techniques
3. Putting It All Together
I just found out I will be presenting at the PowerShell Deep Dive April 18-19 that is part of TEC 2011. This promises to be THE PowerShell event everyone has been waiting for. I’ll be presenting on format and type extensions.
Mastering Format and Type Extensions
Windows PowerShell is designed with administrators in mind. The goal is to present the most useful information to you with the least amount of effort. But sometimes you need something out of the box. Do you have a preferred way to view process objects that requires scripting every time? Does your script create a custom object that you would like formatted in a specific manner? This session will explain PowerShell’s formatting system and how to master it with your own formatting and type extension files, including how to incorporate these files into your scripts and modules
I’m excited about this conference and home to see many of you there. Seats are limited so make your plans sooner rather than later. Here’s the place to start.