Browse by Tags

Tagged Content List
  • 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...
  • Blog Post: Hey, Scripting Guy! How Can I Retrieve the Custom Properties of a Microsoft Word Document?

    Hey Scripting Guy! One of the things that I hate about Microsoft Word is the custom properties that can be set on a document. Ok, well maybe I do not actually hate the custom properties. In fact, I would love to love them. The problem is that after they are set, they actually seem to disappear forever...
  • Blog Post: Hey, Scripting Guy! How Do I Center Contents of a Column in Office Excel?

    Hey, Scripting Guy! When I add data to an Office Excel spreadsheet, it always seems to put stuff on the right side of the column. I would like to know how to center the contents of a column. I do not think it should be that hard, but I just cannot figure it out. - LK Hi LK, Did you try Open Sesame...
  • Blog Post: Use PowerShell to Create a Word Table that Shows Fonts

    Summary : Microsoft Scripting Guy, Ed Wilson, shows how to use Windows PowerShell to create a Word table that shows different fonts. Microsoft Scripting Guy, Ed Wilson, is here. We are half finished with Microsoft TechEd 2012 in Orlando, Florida. Last night was Community Night, and it was great to...
  • Blog Post: Hey, Scripting Guy! How Can I Create a Windows Visio Drawing of My Workstations' Disk Subsystem?

    Hey, Scripting Guy! I would like to do a drawing of the disk subsystem on my workstations. We are getting ready to upgrade to Windows 7, and I want to find out which computers have drives that are more than 50 percent full. In addition, I need to know the size of the drives. If I could make a Microsoft...
  • Blog Post: Hey, Scripting Guy! Can I Make a Microsoft Visio Drawing with Network Shapes and Symbols?

    Hey, Scripting Guy! I have been excited about the Microsoft Visio Week articles since I heard your interview back during the holidays. When I read your tweets as you were the writing the Hey, Scripting Guy! posts, I really got excited. I must say that reading yesterday’s article where you added a square...
  • Blog Post: Hey, Scripting Guy! How Can I Search For Values in an Excel Worksheet?

    Hey, Scripting Guy! How can I use Excel’s Find method to search for values within a worksheet? -- SK Hey, SK. Before we begin today, we have a question for you, and for everyone else out there in Scripting Land. Back when the Scripting Guys first started planning the 2008 Winter Scripting Games (February...
  • Blog Post: Hey, Scripting Guy! How Can I Remove the Speaker Notes From a PowerPoint Presentation?

    Hey, Scripting Guy! We have a whole bunch of PowerPoint presentations that we would like to share with other people. However, before we make these presentations available we’d like to remove all the speaker notes from each one. Is there a way we can use a script to remove the speaker notes from...
  • Blog Post: How Can I Copy a Worksheet to a New Spreadsheet?

    Hey, Scripting Guy! How can I copy a worksheet in an existing Excel spreadsheet to a new spreadsheet? -- TY Hey, TY. Before we tackle your question we wanted to note that, as we write this, the University of Washington football team has a winning record. Sure, we’re only three weeks into the college...
  • Blog Post: How Can I Rename a Word Document Using the First Three Characters in That Document?

    Hey, Scripting Guy! How can I open a Word document, read the first three characters, and then rename the file using those three characters? -- DG Hey, DG. To tell you the truth, we always get a chuckle any time we get a question that asks for our help in renaming files or folders. Why? Well, the Scripting...
  • Blog Post: Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

    Hey, Scripting Guy! I loved your last "Hey, Scripting Guy!" article about formatting paragraphs in a Microsoft Office Word document. What I need to do is a little bit more mundane, but for me much more important. I have a number of Word documents that are stored in a folder. Unfortunately, the person...