Reading SecureCRT output from Excel VBA

[djvj]

I see all the examples provided here

What I haven't been able to find is the ability to read the output from a session created from within Excel, then read the data from SecureCRT back to Excel, parse and write it to specific cells.

For example, I used the example script "ConnectToSecondaryHost_via_JumpHost_ShellDriverExcel.bas" to connect to a device, run a custom script. I want to take the output from that script and put it back into excel. This has to be done from Excel.

Is this possible?

[bgagnon]

Hi djvj,

What you are asking sounds like the Reading and Writing example found at the forum thread you referenced. In what way does that not meet your needs? What parsing needs done to the data you plan to put into Excel?

[djvj]

Hi Brenda,

Reading and Writing example is done from SecureCRT, not from launching SecureCRT within Excel, telling SecureCRT what to do, then bringing the data back to Excel. Basically extending the ConnectToSecondaryHost_via_JumpHost_ShellDriverExcel example to get the output back to the same Excel spreadsheet.

[bgagnon]

Hi djvj,

Sorry, I did not pickup on that distinction. I was thinking session *data* would be stored in Excel and you would use that for the SecureCRT session. Correct, SecureCRT is not externally scriptable, so that's not currently possible.

I have added this thread to a feature request in our product enhancement database to expose CRT object API so external programming editors can reference methods and properties. Should a future release of SecureCRT include this feature, notification will be posted here.

If you prefer direct email notification, send an email to support@vandyke.com and include Feature Request - Forum Thread #14545 in the subject line or use this form from the support page of our website.

[djvj]

Ok Thank you. I was hoping for some ability to do now. I'll play around with the dynamic script option and see if I can figure something out for now. Just not sure an open workbook is writable from outside like that.

[bgagnon]

Hi djvj,

I believe it is because the aforementioned script does it.