I can’t disclose my source, but let me assure you that Office 2015 will definitely rock. The Redmond giant is working intensely on a full integration of PowerShell in the next version of Office, which most likely will be available in 2015.
Profile gravatar of Michael Pietroforte

Michael Pietroforte

Michael Pietroforte is the founder and editor of 4sysops. He is a Microsoft Most Valuable Professional (MVP) with more than 30 years of experience in IT management and system administration.
Profile gravatar of Michael Pietroforte

Update: This post was April Fools.

PowerShell support for Office means two things. First of all, VBA will be deprecated and replaced by PowerShell. For instance, the Word macro recorder will create PowerShell code, which can then be edited in the PowerShell ISE for Office. Microsoft will also offer a new VBA converter, so you will still be able to use your old VBA scripts in Office 2015 once they are converted to PowerShell.

The second (and, for many, probably a more surprising) feature is a new PowerShell command line interface (CLI) for Office. This enhancement will allow you to interact with all Office applications through PowerShell commands. For example, if you want to create a new Word file, you don’t have to click File > New—you would just enter a PowerShell command in the new Office CLI, which will get its own Office Ribbon.

Office PowerShell CLI

Office PowerShell CLI

According to my source, this will allow you to automate typical Office tasks. For example, if there is a new company policy for document formats, you can change Word styles on hundreds of computers with a simple PowerShell script. Imagine all the click-click-click needed if you had to do this manually.

I don’t have to mention that Excel formulas will all be in PowerShell. Every single Excel cell can contain pages of PowerShell code. This will offer secretaries, accountants, managers, and all fans of spreadsheet calculations unlimited automation capabilities.

And, when you start Outlook in the morning, you can fire up a PowerShell command that will (automatically) reply to all emails from your boss with varying texts. For instance, if an email from your boss contains phrases like “as soon as possible,” a PowerShell script could (automatically) reply with “You will have it before lunch in your PowerBox,” (automatically) bc the email to your favorite subordinate, and then—since PowerShell automation saves you a lot of time—launch Angry Birds for Office PowerShell (automatically). And if you really despise clicking, PowerShell can even kill the birds for you (automatically).

I asked my source if Office 2015 will still feature a graphical user interface (GUI) and he said, “Of course, we will always do both CLI and GUI. I mean, Microsoft became big with great GUIs.” When I pressed him to explain exactly what this means, he said, “You will always be able to do everything with PowerShell in Microsoft Office and just a few things with the GUI. This works very well in Exchange, so why not apply this concept to Office?” The new Ribbon in all Office apps will definitely get decluttered. However, at the moment, it is not yet clear which icons will be removed. Some members of the PowerShell team have advocated for removing them all.

He added that things probably wouldn’t go that far, at least not in the next Office version, but advanced Office users will definitely be able to completely disable the GUI and only work with the PowerShell CLI. My source then said, “We can no longer limit Office users. I think there’s going to be quite a crossover or hybrid. I guess we could call it DevClerks.”

I then wondered aloud whether this was a step backwards in time. This new Word somehow reminds me a little of a once very popular, but long forgotten, UNIX editor that allowed you to automate all kinds of text editing tasks. He replied, “Absolutely! The new Word will be the renaissance of the great vi, just with longer commands. You know, embrace and extend.”

I then objected that Microsoft’s main competitors count on easy-to-use graphical touch interfaces and asked if it isn’t a bit risky to confront Office users with a text-based interface in the post-DOS age. He countered that PowerShell 4.0 will fully support Modern apps, so no more need for all this modern tap-tap-tap and desktop click-click-click. It will be all about type-type-type.

Rocks! 😉

Take part in our competition and win $100!

Share
0

Related Posts

5 Comments
  1. avatar
    Daniele 4 years ago

    Nice April Fools'. I would actually love the ability of using PowerShell code inside Excel cells, they should think about that. 😛

    0
  2. Profile gravatar of Michael Pietroforte
    Michael Pietroforte 4 years ago

    Daniele, you won't believe it, but when I read the article again before posting it, I noticed that not everything is so far-fetched as I originally thought. A few years ago I blogged about my wishes for a radical new UI for Windows and hoped that Microsoft would ditch the Start Menu. Later it turned out that at the time when I wrote the post Microsoft was already working on it. Besides, sometimes I really do miss vi. 😉

    0
  3. avatar
    Joseph Moody 4 years ago

    I thought this article was a good tie in.

    http://blogs.technet.com/b/heyscriptingguy/archive/2013/03/24/weekend-scripter-convert-word-documents-to-pdf-files-with-powershell.aspx#comments

    It shows how to use PowerShell to convert word documents to PDFs. Pretty cool!

    0
  4. avatar
    Chris Wright 4 years ago

    It actually took me a while to realise this was an April fools joke! lol the thing that tipped me off the most was you asking if Office 2015 would include a GUI at all haha Excel spreadsheets via Powershell only would be "interesting"

    0
  5. Profile gravatar of Michael Pietroforte
    Michael Pietroforte 4 years ago

    Joseph, indeed pretty cool! There are certainly many ways in how Office could benefit from PowerShell. Maybe I just exaggerated a little. 😉

    Chris, yeah I tried my best to make this sound very unlikely at the end because I don't want to spread false news. I am afraid there are still many who took the story for real. I suppose this shows that quite a few admins are prepared for everything when it comes to PowerShell.

    0

Leave a reply

Your email address will not be published. Required fields are marked *

*

CONTACT US

Please ask IT administration questions in the forum. Any other messages are welcome.

Sending
© 4sysops 2006 - 2017

Log in with your credentials

or    

Forgot your details?

Create Account