none
POWERSHELL SCRIPTING FOR NON-IT/NON-ADMINISTATORS - JUST AN AVERAGE JOE TRYING TO USE CREATE SCRIPTS TO AUTOMATE TASK RRS feed

  • Question

  • Hello All,

    I just discovered Powershell after looking for a something that I could create some simple scripts to automate daily task such as compiling financial reports in excel or coping files between different folders on my PC.  I am not an IT person, and have very little knowledge about programming.  After watching Powershell tutorials on Youtube, I am thinking Powershell is more for IT/System Administrators and not for an average computer users like myself?

    If Powershell is not intended for creating simple scripts to automate daily task for the average user (non-IT professional) then please point me in the right direction?  I am looking for something that works with Microsoft Office products.  I have tried a few Batch files and commmands to open windows and create folders, but have been told these lack security, so I moved on to Linux only to find out its a competitor of Microsoft.  Now I am with Powershell, and it looks very complicated for what I need to get done.

    Please Help!

    Thursday, August 7, 2014 4:56 AM

Answers

  • If you are only using Office products, then you might want to consider VBA (Visual Basic For Applications) which is included in the Office products, especially if you are new to programming, it`s basic. But programming is programming regardless of the programming language. 

    VBA is limited basically to Office products and Powershell is much more powerful and can be used with a wider range of products/features including Office. Powershell is more of scripting language rather than a "programming language".

    To really learn Powershell and see if it meets your needs, check out the Microsoft Virtual Academy courses on Powershell

    Getting Started with PowerShell 3.0 Jump Start
    http://www.microsoftvirtualacademy.com/training-courses/getting-started-with-powershell-3-0-jump-start

    Advanced Tools & Scripting with PowerShell 3.0 Jump Start
    http://www.microsoftvirtualacademy.com/training-courses/advanced-tools-scripting-with-powershell-3-0-jump-start

    • Proposed as answer by jrv Thursday, August 7, 2014 11:24 AM
    • Marked as answer by ScriptingWifeModerator Tuesday, September 16, 2014 7:34 PM
    Thursday, August 7, 2014 5:38 AM

All replies

  • If you are only using Office products, then you might want to consider VBA (Visual Basic For Applications) which is included in the Office products, especially if you are new to programming, it`s basic. But programming is programming regardless of the programming language. 

    VBA is limited basically to Office products and Powershell is much more powerful and can be used with a wider range of products/features including Office. Powershell is more of scripting language rather than a "programming language".

    To really learn Powershell and see if it meets your needs, check out the Microsoft Virtual Academy courses on Powershell

    Getting Started with PowerShell 3.0 Jump Start
    http://www.microsoftvirtualacademy.com/training-courses/getting-started-with-powershell-3-0-jump-start

    Advanced Tools & Scripting with PowerShell 3.0 Jump Start
    http://www.microsoftvirtualacademy.com/training-courses/advanced-tools-scripting-with-powershell-3-0-jump-start

    • Proposed as answer by jrv Thursday, August 7, 2014 11:24 AM
    • Marked as answer by ScriptingWifeModerator Tuesday, September 16, 2014 7:34 PM
    Thursday, August 7, 2014 5:38 AM
  • Thank You Sir!  
    Thursday, August 7, 2014 2:25 PM