Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
bbrumfield
437 Views, 5 Replies

Write value to Excel table for validation

I am attempting to Randomly Generate a Drawing/Program number and add it to an excel spreadsheet, the hope is that my rule would generate the number, check the spreadsheet to make sure it doesn't exist then add the new number in the next available row, if the number does exist a message box prompts the user to generate a new number. Parts of the code work however I am failing measurably at writing to the spread sheet. 

 

Thanks in advance

 

Brent