Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Microsoft Excel   (RSS)
Friday, September 11, 2009 12:01 AM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (9/11/09)

Share this post: Hey Scripting Guy! I stumbled across the TechNet Script Center recently while trying to solve a problem I had at work. I had heard about scripting, of course, but had never taken the time to learn about it. I was able to find a script
Posted by ScriptingGuy | 0 Comments
Thursday, August 20, 2009 12:01 AM

Hey, Scripting Guy! Can I Sort a Tab-Separated Value File with Windows PowerShell 2.0?

Hey Scripting Guy! I have a bunch of data in a tab-separated value (TSV) file that I need to sort based upon one of the columns. If you could help me it would be great. We are using Windows PowerShell 2.0 if that is of any importance to your solution.
Posted by ScriptingGuy | 0 Comments
Friday, May 08, 2009 9:41 PM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (05/08/09)

How Can I List All Servers in a Domain That Have DHCP Installed? Hey, Scripting Guy! How can I quickly produce a list of all servers in the domain that have the DHCP Service installed? - SC Hi SC, On Windows Server 2008 and ater, use the WIN32_ServerFeature
Posted by ScriptingGuy | 0 Comments
Thursday, February 19, 2009 6:15 PM

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does
Posted by ScriptingGuy | 1 Comments
Friday, January 23, 2009 9:32 PM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (01/23/09)

How Can I Return File Names of Files Created in Less Than an Hour from the Current Time? Hey, Scripting Guy! I am attempting to write a script that looks at the creation dates of all files in a certain directory. If the files were created less than an
Posted by ScriptingGuy | 1 Comments
Friday, January 16, 2009 9:31 PM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (01/16/09)

How Do I Set Process Affinity? Hey, Scripting Guy! I have this application that I would like to set process affinity for. I know I can use Task Manager, right-click the process, and choose to set affinity, but I would like to be able to do this from a
Posted by ScriptingGuy | 0 Comments
Thursday, January 15, 2009 8:56 AM

Hey, Scripting Guy! How Can I Modify the Footers of an Office Excel Spreadsheet?

Hey, Scripting Guy! I have a simple question for you: How can I modify the footers in an Office Excel spreadsheet? - MN Hi MN, I have a simple answer for you as well. You assign a value to the appropriate footer property of the pagesetup object. If you
Posted by ScriptingGuy | 0 Comments
Wednesday, January 14, 2009 8:55 AM

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
Posted by ScriptingGuy | 0 Comments
Tuesday, January 13, 2009 8:55 AM

Hey, Scripting Guy! How Do I Run an Office Excel Macro on Multiple Workbooks?

Hey, Scripting Guy! I don't know about you, but I love Microsoft Office Excel macros. Come Valentine's Day , my computer gets a card. Office Excel macros save me so much time, it is just unbelievable. There is just one problem, and that is that I have
Posted by ScriptingGuy | 0 Comments
Monday, January 12, 2009 8:54 AM

Hey, Scripting Guy! How Can I Add a Function to an Office Excel Spreadsheet?

Hey, Scripting Guy! I need to add some data to an Excel spreadsheet. After I have done that, I would like to add a function to the bottom that will add up all the information in the columns above that. I have seen examples of plugging data into cells,
Posted by ScriptingGuy | 0 Comments
Friday, November 28, 2008 9:28 PM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (11/28/08)

“File Not Found” Error When Trying to Run a PowerPoint Presentation from the Windows XP Desktop Hey, Scripting Guy! I have a problem when I try to run a Microsoft Office PowerPoint slideshow that I have saved on the desktop of my Windows XP computer.
Posted by ScriptingGuy | 0 Comments
Thursday, November 27, 2008 8:28 AM

Hey, Scripting Guy! How Can I Pull Server Diagnostic Information and Have It Saved in an Excel Spreadsheet with a Chart?

Hey, Scripting Guy! Good morning. I would like to use WMI to get diagnostic information for my server. I would like to be able to do this remotely and to write the results to an Excel spreadsheet. When I am done, I would like the spreadsheet to also create
Posted by ScriptingGuy | 1 Comments
Thursday, October 09, 2008 8:09 AM

Hey, Scripting Guy! How Can I Read Microsoft Excel Metadata?

Hey, Scripting Guy! I have a VBScript script that reads Microsoft Office Excel metadata. I would like to update the script to Windows PowerShell, but can I do this? I tried using New-Object to create the Excel.Application object but somehow it does not
Posted by ScriptingGuy | 1 Comments
Monday, September 15, 2008 11:24 PM

Hey, Scripting Guy! How Can I Write to Excel Without Using Excel?

Hey, Scripting Guy! I need to be able to write information to an Excel file. I do not want to install Microsoft Office Excel on my server, but the spreadsheet format is a nice way to store information. I can then give it to my pointy-headed boss, and
Posted by ScriptingGuy | 0 Comments
Thursday, September 11, 2008 11:23 PM

Hey, Scripting Guy! How Can I Read from Excel Without Using Excel?

Hey, Scripting Guy! I have an Microsoft Office Excel spreadsheet with server names in it, and I would like to be able to use this in a Windows PowerShell script. The thing is, I do not have Microsoft Office or Excel installed on the server. How can I
Posted by ScriptingGuy | 1 Comments
More Posts Next page »
 
Page view tracker