View Single Post
Old 08-05-2021, 07:40 PM
djvj djvj is offline
Registered User
Join Date: Oct 2011
Posts: 13
Originally Posted by gregg View Post

I might be missing something, but this script will update a cell in an Open excel sheet with new data. I think the difference is GetObject vs CreateObject

It's lacking a lot of error handling, but does update the already opened excel workbook/sheet/cell with the new value. The commented out WScript.Arguments bits were for testing from the command line but the script also ran inside of sCRT v9 just fine.
Let me get this straight, you ran that with an open spreadsheet, and saw the cells update on the sheet and didn't have to reload the spreadsheet to see the new values?
Reply With Quote