Where I am at, it is not allowed to install any software. I need to automate some tasks and I cannot do it in powershell because it is not allowed. Are there any languages already installed on windows that i can use to automate and probably integrate with microsoft office?
VBScript (WSH/CSCRIPT), Batch (MS Command Shell typically referred to as DOS), through Office Applications themselves you have VBA (Visual Basic for Applications)
Yes, you can run VBScript and JScript through Windows Script Host. While using these languages, you can create objects to interact with Microsoft Office.
EDIT:
I've found the documentation for WSH fairly lacking, especially for JScript examples. Recently I wrote a script to print all files in a folder and subfolders, had to use JScript because my target machine was under similar restrictions to yours. Check out this gist for the source, it should give you a rough idea of how WSH scripts can work.
Beyond that, you can interact with Excel, for example, by calling CreateObject("Excel.Application")
and using the returned object. I had to do this once, but that code belongs to a former employer and I can't remember the specifics beyond grabbing an Excel instance.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With