View Single Post
  #11  
Old 05-27-2021, 07:49 PM
djvj djvj is offline
Registered User
 
Join Date: Oct 2011
Posts: 13
Right, it can be confusing. But yea since Excel uses VBA, and the syntax is the same as VBS, just thought SecureCRT supported VBA.

Now Python I'm good with if my solution could be had using that language, but Excel doesn't support that. So still back to square one.

UPDATE

I played around with the read/write VBS script example. So it works with writing to excel fine, but its limit is if the workbook is open, it doesn't update it. The workbook has to be closed, which doesn't work for what I'm trying to do. Brings me back to my initial request.

For the time being, I'm going to try and get creative and use a 2nd workbook to control the one I want to update. In my head it should work, but not as intuitive and much more convoluted vs quickly updating a couple of cells.

Last edited by djvj; 05-28-2021 at 02:10 AM.
Reply With Quote