Browse by Tags

Tagged Content List
  • Blog Post: Use PowerShell to Count Comments in Word Docs

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to count comments in Microsoft Word documents. Microsoft Scripting Guy, Ed Wilson, is here. The process of writing often includes rewriting. In fact, I imagine that I spend more time rewriting stuff than I spent writing...
  • Blog Post: Weekend Scripter: Add Comment to Word Doc

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to add a comment to a Microsoft Word document. Microsoft Scripting Guy, Ed Wilson, is here. I spend a lot of time using Microsoft Word. In fact, I spend more time using Word than Microsoft Outlook—and that is...
  • Blog Post: Use PowerShell to Add Table to Word Doc and Email as Attachment

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to create a document in Microsoft Word, add a table, and email the document as an attachment. Microsoft Scripting Guy, Ed Wilson, is here. One of the cool things I like to do with Windows PowerShell is to combine multiple...
  • Blog Post: Add Custom Headers to Folder Full of Word Documents

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about reading a CSV file and adding custom headers to a folder full of Word documents. Microsoft Scripting Guy, Ed Wilson, is here. The snow continues to befuddle the drivers around here, and as a result, the Scripting Wife and I are staying home...
  • Blog Post: Use PowerShell to Add Headers to Word Documents

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to add headers to Microsoft Word documents. Microsoft Scripting Guy, Ed Wilson, is here. It snowed in Charlotte yesterday. It was not really a surprise because the weather service did a good job of warning that it would...
  • Blog Post: PowerTip: Use PowerShell to List Word Autocorrect Entries

    Summary : Use Windows PowerShell to list autocorrect entries for Microsoft Word. Microsoft Word keeps messing up what I type, and I suspect it could be an autocorrect issue. How can I use Windows PowerShell to list all the entries in Microsoft Word autocorrect? Use the New-Object cmdlet to create...
  • Blog Post: Use PowerShell to Report on Exchange Online

    Summary : Use the Windows PowerShell cmdlets to generate Exchange Online information. Microsoft Scripting Guy, Ed Wilson, is here. This morning, I have a meeting with my manager, and this afternoon, I am meeting with a couple of teammates. The meetings will bookend another wonderful day of Windows...
  • Blog Post: Use PowerShell to Produce Mailbox Activity Report

    Summary : Use Windows PowerShell to produce a mailbox activity report for Office 365. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am sipping a cup of pomegranate black tea, and nibbling on a fresh blueberry scone. I am using my Windows Surface Pro 2 to check my email, and to make sure...
  • Blog Post: Use PowerShell for Office 365 Reporting

    Summary : Use Windows PowerShell to query the Office 365 Reporting web service. Hey, Scripting Guy! There are a lot of reports available via various buttons on the Office 365 Admin page, but only a few seem to have a cmdlet to back them up. Is there a way that I can use Windows PowerShell to automate...
  • Blog Post: Use PowerShell to Force Office 365 Online Users to Change Passwords

    Summary : Use Windows PowerShell to force Office 365 online users to change their passwords. Hey, Scripting Guy! I used your technique from yesterday to create a bunch of Office 365 users online, and now I want to force them to change their passwords. If I could also make them use a complex password...
  • Blog Post: Manage Office 365 SharePoint with Modules

    Summary : Learn how to use Office 365 SharePoint Online modules to manage Office 365 SharePoint. Microsoft Scripting Guy, Ed Wilson, is here. In a couple of days, the Scripting Wife and I will be at the Dutch PowerShell User Group in Amsterdam. If you are anywhere in the area, you should try to come...
  • Blog Post: Use PowerShell to Manage Exchange Online in Office 365

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell implicit remoting to manage Exchange Online users. Microsoft Scripting Guy, Ed Wilson, is here. This afternoon I am looking over my presentations for the PowerShell Summit in Bellevue, Washington . It will be April...
  • Blog Post: Use PowerShell to Manage Office 365 Users

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to manage Office 365 users. Microsoft Scripting Guy, Ed Wilson, is here. The weather here in Charlotte has been nearly perfect recently. I love spring. It offers hope, and it seems to be a time of renewed commitments...
  • Blog Post: Use PowerShell to Explore Office 365 Installation

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to explore his Office 365 tenant installation. Microsoft Scripting Guy, Ed Wilson, is here. The Scripting Wife and I are sore from our weekend spent doing yard work. I am not much of an outdoor kind of geek, and so...
  • Blog Post: Getting Started with Office 365 and PowerShell

    Summary : Microsoft Scripting Guy, Ed Wilson, talks about getting started with Office 365 and Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. This morning I am sipping a nice cup of First Flush Charleston Tea. I added bits of spearmint, peppermint, cinnamon stick, lemon, and local...
  • Blog Post: How Can I Delete Unread Emails That Are More Than 6 Months Old?

    Hey, Scripting Guy! We have a lot of users who let unread email messages pile up in their Outlook Inboxes; after awhile, that causes their Inboxes to fill up. How can I write a script users could run that would delete any unread messages that are more than 6 months old? -- ST Hey, ST. You know, sometimes...
  • Blog Post: How Can I Save Word Documents as Text Files By Using a Script?

    Hey, Scripting Guy! I have a series of Word files. I would like to open each of these files and save them as plain-text files. Is there a way to do that using a script? -- CG Hey, CG. Yes, you can do this quite easily with a script; in fact, with very few exceptions anything you can do within a Microsoft...
  • Blog Post: How Can I Determine the Last Row in an Excel Spreadsheet?

    Hey, Scripting Guy! How can I determine the last row in an Excel spreadsheet? I can’t append data to the file unless I know which row to start with. -- TGW Hey, TGW. You know, this is the kind of thing that separates the Scripting Guys from the rest of the world. Most people would do the same thing...
  • Blog Post: How Can I Change the Footer in an Excel Spreadsheet?

    Hey, Scripting Guy! How can I change the footer in an Excel spreadsheet? -- JA Hey, JA. Ah, a trick question, huh? As it turns out, there’s no such thing as the footer in Excel; instead, Excel has three different footers: the left footer, the center footer, and the right footer. And here’s a script...
  • Blog Post: How Can I Use a Blank Row to Separate Data in an Excel Spreadsheet?

    Hey, Scripting Guy! How can I use a blank row to separate rows of data in a Microsoft Excel spreadsheet? -- AR Hey, AR. You know, most people believe that the Scripting Guys all think alike, that we always agree on everything. That’s not true, though; instead, like any other team, we disagree from...
  • Blog Post: How Can I Change the User Information in Microsoft Office?

    Hey, Scripting Guy! How can I change the user information in Microsoft Office to match the user’s name as stored in Active Directory? -- SM Hey, SM. Back in the days when one of the Scripting Guys worked for a local university, every document in one department of 300+ users appeared to have been created...
  • Blog Post: Troubleshoot a WMI VBScript and Handle Outlook File Locking

    Summary: Learn how to troubleshoot a WMI VBScript and how to handle Outlook .pst file locking issues in Windows PowerShell. In this post: · Troubleshoot a WMI VBScript · How to Handle Outlook File Locking Troubleshoot a WMI VBScript Hey, Scripting Guy! I am busy learning...
  • Blog Post: How Can I Add a Blank Line Between the Existing Paragraphs in a Word Document?

    Hey, Scripting Guy! How can I add a line between the existing paragraphs in a Word document? -- GB Hey, GB. You’ll have to forgive us if we seem a little distracted this morning; shocking as this might seem, the Scripting Guy who writes this column may have made a monumental mistake. In yesterday...
  • Blog Post: How Can I Search a Word Document for All the Words in Double Brackets?

    Hey, Scripting Guy! How can I search a Word document for all the words in double brackets? For example, I need to find words like this: [[failed]]. I then need to save the words I find to a text file. -- PP Hey, PP. You know, one thing that seems to be true of the Scripting Guys is a willingness to...
  • Blog Post: How Can I Copy and Rename a Worksheet in the Same Workbook?

    Hey, Scripting Guy! I’d like to copy one of the worksheets in an Excel workbook and then paste that copy into the very same workbook; once it’s pasted it, I’d like to rename it. Can I do that? -- JG Hey, JG. Of course you can do this; after all, if you can do something in Excel it’s almost 100% guaranteed...