{"id":2281,"date":"2012-05-10T08:56:43","date_gmt":"2012-05-10T12:56:43","guid":{"rendered":"http:\/\/jdhitsolutions.com\/blog\/?p=2281"},"modified":"2012-05-10T08:56:43","modified_gmt":"2012-05-10T12:56:43","slug":"quick-and-dirty-excel-from-powershell","status":"publish","type":"post","link":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/","title":{"rendered":"Quick and Dirty Excel from PowerShell"},"content":{"rendered":"<p><a href=\"http:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo-150x150.png\" alt=\"\" title=\"excel_2010_logo\" width=\"150\" height=\"150\" class=\"alignleft size-thumbnail wp-image-2282\" srcset=\"https:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo-150x150.png 150w, https:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo.png 204w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a> I continue to tinker with Office applications and Windows PowerShell. I was looking at an Excel issue related to opening a new workbook. To verify the problem wasn't PowerShell related I offered a suggestion to try creating an Excel workbook in VBScript.<\/p>\n<p>In VBScript creating a blank workbook in Microsoft Excel can be accomplished with three lines of code.<\/p>\n<p><code lang=\"VB\"><br \/>\nset xl=wscript.createObject(\"Excel.Application\")<br \/>\nset wb=xl.workbooks.add()<br \/>\nxl.Visible=vbTrue<br \/>\n<\/code><\/p>\n<p>In Windows PowerShell we essentially use the same 3 lines.<\/p>\n<p><code lang=\"PowerShell\"><br \/>\n$xl=new-object -com \"excel.application\"<br \/>\n$sb=$xl.Workbooks.Add()<br \/>\n$xl.Visible=$True<br \/>\n<\/code><\/p>\n<p>But PowerShell is all about the objects, so how about a quick and dirty approach? Something perhaps in one line:<\/p>\n<p><code lang=\"PowerShell\"><br \/>\nPS S:\\> ((new-object -com \"excel.application\").Workbooks.Add()).application.Visible=$True<br \/>\n<\/code><\/p>\n<p>You could easily build a simple function to run the 3 lines it takes to open a new Excel workbook but one-liners like this make me smile. Granted, I'm probably not likely to use it, but if nothing else I think it reinforces the object nature of Windows PowerShell. <\/p>\n<p>Each expression nested in () is treated as an object. The inner most expression using New-Object, creates the Excel application object which has a Workbooks property that is an object with an Add() method. Invoking this method creates the workbook object. If I stopped there Excel would be running but not visible. So I get the Application property of the workbook object, and set the Visible property to True.<\/p>\n<p>This command doesn't offer any way to continue working with Excel from PowerShell; it only opens a new workbook. Let me be clear, I'm not advocating that this is how you work with Excel from PowerShell. I think you will need scripts like the ones I posted from my <a href=\"http:\/\/bit.ly\/IYXpOF\" title=\"San Diego 2012 PowerShell Deep Dive Slides and Demos\" target=\"_blank\">Deep Dive session<\/a>. But this one-liner demonstrates what is possible with PowerShell and maybe it will add a little smile to your day as well.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I continue to tinker with Office applications and Windows PowerShell. I was looking at an Excel issue related to opening a new workbook. To verify the problem wasn&#8217;t PowerShell related I offered a suggestion to try creating an Excel workbook in VBScript. In VBScript creating a blank workbook in Microsoft Excel can be accomplished with&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[61,4],"tags":[377,534,540],"class_list":["post-2281","post","type-post","status-publish","format-standard","hentry","category-miscellaneous","category-powershell","tag-excel","tag-powershell","tag-scripting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Quick and Dirty Excel from PowerShell &#8226; The Lonely Administrator<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Quick and Dirty Excel from PowerShell &#8226; The Lonely Administrator\" \/>\n<meta property=\"og:description\" content=\"I continue to tinker with Office applications and Windows PowerShell. I was looking at an Excel issue related to opening a new workbook. To verify the problem wasn&#039;t PowerShell related I offered a suggestion to try creating an Excel workbook in VBScript. In VBScript creating a blank workbook in Microsoft Excel can be accomplished with...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"The Lonely Administrator\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-10T12:56:43+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo-150x150.png\" \/>\n<meta name=\"author\" content=\"Jeffery Hicks\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JeffHicks\" \/>\n<meta name=\"twitter:site\" content=\"@JeffHicks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeffery Hicks\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/\"},\"author\":{\"name\":\"Jeffery Hicks\",\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0258030b41f07fd745f4078bdf5b6c9\"},\"headline\":\"Quick and Dirty Excel from PowerShell\",\"datePublished\":\"2012-05-10T12:56:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/\"},\"wordCount\":288,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0258030b41f07fd745f4078bdf5b6c9\"},\"image\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/jdhitsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/05\\\/excel_2010_logo-150x150.png\",\"keywords\":[\"Excel\",\"PowerShell\",\"Scripting\"],\"articleSection\":[\"Miscellaneous\",\"PowerShell\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/\",\"url\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/\",\"name\":\"Quick and Dirty Excel from PowerShell &#8226; The Lonely Administrator\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/jdhitsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/05\\\/excel_2010_logo-150x150.png\",\"datePublished\":\"2012-05-10T12:56:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/#primaryimage\",\"url\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/05\\\/excel_2010_logo.png\",\"contentUrl\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/05\\\/excel_2010_logo.png\",\"width\":\"204\",\"height\":\"204\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/powershell\\\/2281\\\/quick-and-dirty-excel-from-powershell\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Miscellaneous\",\"item\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/category\\\/miscellaneous\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Quick and Dirty Excel from PowerShell\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/\",\"name\":\"The Lonely Administrator\",\"description\":\"Practical Advice for the Automating IT Pro\",\"publisher\":{\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0258030b41f07fd745f4078bdf5b6c9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/jdhitsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0258030b41f07fd745f4078bdf5b6c9\",\"name\":\"Jeffery Hicks\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/832ae5d438fdcfc1420d720cd1991307927de8a0b12f2342e81c30f773e21098?s=96&d=wavatar&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/832ae5d438fdcfc1420d720cd1991307927de8a0b12f2342e81c30f773e21098?s=96&d=wavatar&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/832ae5d438fdcfc1420d720cd1991307927de8a0b12f2342e81c30f773e21098?s=96&d=wavatar&r=pg\",\"caption\":\"Jeffery Hicks\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/832ae5d438fdcfc1420d720cd1991307927de8a0b12f2342e81c30f773e21098?s=96&d=wavatar&r=pg\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Quick and Dirty Excel from PowerShell &#8226; The Lonely Administrator","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/","og_locale":"en_US","og_type":"article","og_title":"Quick and Dirty Excel from PowerShell &#8226; The Lonely Administrator","og_description":"I continue to tinker with Office applications and Windows PowerShell. I was looking at an Excel issue related to opening a new workbook. To verify the problem wasn't PowerShell related I offered a suggestion to try creating an Excel workbook in VBScript. In VBScript creating a blank workbook in Microsoft Excel can be accomplished with...","og_url":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/","og_site_name":"The Lonely Administrator","article_published_time":"2012-05-10T12:56:43+00:00","og_image":[{"url":"http:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo-150x150.png","type":"","width":"","height":""}],"author":"Jeffery Hicks","twitter_card":"summary_large_image","twitter_creator":"@JeffHicks","twitter_site":"@JeffHicks","twitter_misc":{"Written by":"Jeffery Hicks","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/#article","isPartOf":{"@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/"},"author":{"name":"Jeffery Hicks","@id":"https:\/\/jdhitsolutions.com\/blog\/#\/schema\/person\/d0258030b41f07fd745f4078bdf5b6c9"},"headline":"Quick and Dirty Excel from PowerShell","datePublished":"2012-05-10T12:56:43+00:00","mainEntityOfPage":{"@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/"},"wordCount":288,"commentCount":2,"publisher":{"@id":"https:\/\/jdhitsolutions.com\/blog\/#\/schema\/person\/d0258030b41f07fd745f4078bdf5b6c9"},"image":{"@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/#primaryimage"},"thumbnailUrl":"http:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo-150x150.png","keywords":["Excel","PowerShell","Scripting"],"articleSection":["Miscellaneous","PowerShell"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/","url":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/","name":"Quick and Dirty Excel from PowerShell &#8226; The Lonely Administrator","isPartOf":{"@id":"https:\/\/jdhitsolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/#primaryimage"},"image":{"@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/#primaryimage"},"thumbnailUrl":"http:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo-150x150.png","datePublished":"2012-05-10T12:56:43+00:00","breadcrumb":{"@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/#primaryimage","url":"https:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo.png","contentUrl":"https:\/\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2012\/05\/excel_2010_logo.png","width":"204","height":"204"},{"@type":"BreadcrumbList","@id":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2281\/quick-and-dirty-excel-from-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Miscellaneous","item":"https:\/\/jdhitsolutions.com\/blog\/category\/miscellaneous\/"},{"@type":"ListItem","position":2,"name":"Quick and Dirty Excel from PowerShell"}]},{"@type":"WebSite","@id":"https:\/\/jdhitsolutions.com\/blog\/#website","url":"https:\/\/jdhitsolutions.com\/blog\/","name":"The Lonely Administrator","description":"Practical Advice for the Automating IT Pro","publisher":{"@id":"https:\/\/jdhitsolutions.com\/blog\/#\/schema\/person\/d0258030b41f07fd745f4078bdf5b6c9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jdhitsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/jdhitsolutions.com\/blog\/#\/schema\/person\/d0258030b41f07fd745f4078bdf5b6c9","name":"Jeffery Hicks","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/832ae5d438fdcfc1420d720cd1991307927de8a0b12f2342e81c30f773e21098?s=96&d=wavatar&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/832ae5d438fdcfc1420d720cd1991307927de8a0b12f2342e81c30f773e21098?s=96&d=wavatar&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/832ae5d438fdcfc1420d720cd1991307927de8a0b12f2342e81c30f773e21098?s=96&d=wavatar&r=pg","caption":"Jeffery Hicks"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/832ae5d438fdcfc1420d720cd1991307927de8a0b12f2342e81c30f773e21098?s=96&d=wavatar&r=pg"}}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":2766,"url":"https:\/\/jdhitsolutions.com\/blog\/powershell\/2766\/building-excel-reports-with-powershell\/","url_meta":{"origin":2281,"position":0},"title":"Building Excel Reports with PowerShell","author":"Jeffery Hicks","date":"January 30, 2013","format":false,"excerpt":"Last year I wrote a series of articles for the Petri IT KnowledgeBase on using Microsoft Excel with PowerShell. Today I received an email from a reader who had a question about article that showed how to build a drive usage report in Excel. In the article I suggest it\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/jdhitsolutions.com\/blog\/category\/powershell\/"},"img":{"alt_text":"MultiExcelDiskReport","src":"https:\/\/i0.wp.com\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2013\/01\/MultiExcelDiskReport-1024x555.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2013\/01\/MultiExcelDiskReport-1024x555.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/jdhitsolutions.com\/blog\/wp-content\/uploads\/2013\/01\/MultiExcelDiskReport-1024x555.png?resize=525%2C300 1.5x"},"classes":[]},{"id":137,"url":"https:\/\/jdhitsolutions.com\/blog\/powershell\/137\/my-published-works\/","url_meta":{"origin":2281,"position":1},"title":"My Published Works","author":"Jeffery Hicks","date":"March 10, 2008","format":false,"excerpt":"I'm trying out a new Live Write plugin for Amazon. Here is a list of books I have currently authored or co-authored. This list will continue to grow as I'm working on a new book now about managing Active Directory with PowerShell. WSH and VBScript Core: TFM by Jeffery Hicks\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/jdhitsolutions.com\/blog\/category\/powershell\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":41,"url":"https:\/\/jdhitsolutions.com\/blog\/powershell\/41\/autographed-copies-of-advanced-vbscript\/","url_meta":{"origin":2281,"position":2},"title":"Autographed copies of Advanced VBScript","author":"Jeffery Hicks","date":"August 4, 2006","format":false,"excerpt":"If you haven't picked up a copy of Advanced VBScript for Microsoft Windows Administrators, you can purchase autographed copies at ScriptingOutpost.com at a great price. The books are signed by Don and myself.Visit http:\/\/www.scriptingoutpost.com\/ProductInfo.aspx?productid=BK-ADV-VBSTechnorati Tags:VBScriptScripting","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/jdhitsolutions.com\/blog\/category\/powershell\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":40,"url":"https:\/\/jdhitsolutions.com\/blog\/powershell\/40\/search-inside-advanced-vbscript-for-windows\/","url_meta":{"origin":2281,"position":3},"title":"Search Inside Advanced VBScript for Windows","author":"Jeffery Hicks","date":"July 25, 2006","format":false,"excerpt":"My first writing effort, Advanced VBScript for Microsoft Windows Administrators, has been very popular and I want to thank all of you who picked up a copy. I see now that Amazon has our book setup for Search Inside. Now you can read an excerpt, see the table of contents,\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/jdhitsolutions.com\/blog\/category\/powershell\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":515,"url":"https:\/\/jdhitsolutions.com\/blog\/powershell\/515\/find-that-service\/","url_meta":{"origin":2281,"position":4},"title":"Find That Service","author":"Jeffery Hicks","date":"November 19, 2009","format":false,"excerpt":"Once again, the fine forum members at ScriptingAnswers.com come through and help get my PowerShell idea engine revving. The latest post posed this basic question: \u201cI need to query my servers and find all services using a specific service account.\u201d The poster thought this would be a good opportunity to\u2026","rel":"","context":"In &quot;CommandLine&quot;","block_context":{"text":"CommandLine","link":"https:\/\/jdhitsolutions.com\/blog\/category\/commandline\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":115,"url":"https:\/\/jdhitsolutions.com\/blog\/powershell\/115\/vbscript-training-in-las-vegas\/","url_meta":{"origin":2281,"position":5},"title":"VBScript Training in Las Vegas","author":"Jeffery Hicks","date":"August 24, 2007","format":false,"excerpt":"I will be doing a live 2 day VBScript class this fall in Las Vegas (Oct. 22 and 23). I'll be covering ADSI, WMI, HTAs, WSF and more. This is a class for experienced VBScripters who want to take it to the next level. This is a hands on class\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/jdhitsolutions.com\/blog\/category\/powershell\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=2281"}],"version-history":[{"count":0,"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2281\/revisions"}],"wp:attachment":[{"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=2281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=2281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jdhitsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=2281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}