I recently had to troubleshoot an issue where a number of people were unable to publish to their blog from Microsoft Word 2010. They would get the error Word cannot publish this post, and pressing CTRL+SHIFT+I revealed error 701797 in the dialog box. The same error occurred on both SharePoint 2010 and WordPress. There …
Read MoreI've often had the need to take a list of computers or servers and run the same command against all of them, and then take some result from that command to report back on. For example, I may want to ping a list of machines and log the response times, or perhaps check the status of BitLocker using manage-bde. Typically, …
Read MoreThis post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author. I was recently tasked with adjusting the DCOM Security Settings (DCOM: Machine Access Restrictions and DCOM: Machine Launch Restrictions) in the local security …
Read MoreThis post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author. I’ve updated my Microsoft Excel PingCell code that I published previously. The new function returns all results from Win32_PingStatus back to Excel. You can now ping …
Read MoreThis post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author. I created the following function to create Microsoft SMS 2003 Client Configuration Requests from within Excel and dump them all out into a temporary directory for me …
Read MoreI was excited to find out recently that Notepad++ has a plug-in that will allow you to edit files on an FTP server. The plug-in, which has come with Notepad++ since v4.7, is FTP_Synchronize. Unfortunately, although I’m on Notepad++ 5.2, the plug-in did not work out of the box for me. While I could connect to and browse …
Read MoreI frequently find myself needing to create lists of values I have in Excel in one cell. For example, I might get have a column of IDs and I need to create a comma delimited list of them to put into a SQL Query. I have the following function I put in an XLA that loads with Excel to generate these lists. 1Public Function …
Read MoreThe following AutoIt script will allow you to set the Microsoft Office Registered User Name, Initials, and Company via a script by getting the name information from Active Directory and modifying the keys . This is useful in corporate environments where you don’t want it to have a generic name when you’re being told …
Read MoreI wrote this tip for the McAfee Community back in December 2008 and thought it would be useful to post here With the Netware client we’re using, we found that when implementing SSO through Safeboot that if a laptop was off our network but on another network (such as home wireless) that the user would get an error …
Read MoreI wrote this tip for the McAfee Community back in November 2008 and thought it would be useful to post here. I do not work for McAfee or for SafeBoot and I’m only posting this because I documented it all out when I was having trouble so that I could fix it in the future and thought it might help someone else. You …
Read More