I am trying to script a way to generate SSH output in a repeated, scheduled fashion and then export the output data to a CSV or TXT file. I have this mostly figured out using Excel and VBA scripting but the one big stumbling block right now is that I am having to run a bat file to initiate the SSH session. For this reason, the script is having to login and authenticate a new SSH session each time as opposed to simply keeping one SSH session open and executing the desired commands. While this isn't a complete show stopper for me, it is still not quite as clean as I would like it to be.
I have seen there is an active x library that is supposed to allow for running SSH out of VBA/Excel but it is a very old library - MSWINSCK.OCX. In fact, it isn't even available in any official Microsoft sanctioned manner. I had to get it off of an older install of Windows 2008r2 that I had. Even once I found it, I wasn't able to get it working as it just generated an error message while trying to run the VBA module.
In case it isn't obvious, I am new to scripting. Hopefully there is an easy answer for this for someone more experienced.
No comments:
Post a Comment