Thanks Garry, I Have tried reinstalling as well as trying to register the dll / osx components and the regsvr32 gives me errors when trying. i also tried soem reboots and repairing office install.
I Will give nodeRed a try, i was honestly planning some python scripting to accomplish this until i came across your VBA post and figured it may be simple to implement but it has proven not to on this computer (Not your fault)/
I Was also just taking a look while i was commissioning IO, as they were very slow but it Isnt an urgent matter. Startup is tomorrow, gotta do some networking yet so ill probably do that next then try nodeRed. Just figured it would be nice to Have the Runsheet auto-populate the values that we have Transmitters for (little one off site) Thanks again for the response.
I Will give nodeRed a try, i was honestly planning some python scripting to accomplish this until i came across your VBA post and figured it may be simple to implement but it has proven not to on this computer (Not your fault)/
I Was also just taking a look while i was commissioning IO, as they were very slow but it Isnt an urgent matter. Startup is tomorrow, gotta do some networking yet so ill probably do that next then try nodeRed. Just figured it would be nice to Have the Runsheet auto-populate the values that we have Transmitters for (little one off site) Thanks again for the response.