How to retrieve a cell value/row from a list

Learn Academy Feedback
, , ,
1

Hi all,

I have a column of IDs stored in excel sheet to generate report on a daily basis:
001
002
003
004
…
999

My ReportCreatingBot runs daily to make sure our web app is stable, and reports get generated successfully.
If code 001 is used today, it can not be used tomorrow. I’m wondering how should I get a new fresh ID daily and make sure no duplicates? I was thinking to get first used row value, and delete row after the bot runs. I’m not very good at VB methods to get the first used row… can anyone help?

2

@Zoe_1020
if for example Orchestrator is in use different options would be available
But if you are free on ID Value there is common to use the date
now.toString(“ddMMYYYY”)
and if your Bot is multiple times a day the time parrt is added
now.toString(“ddMMYYYY_hhmmss”) or without ss for the seconds

Maybe this works your scenario

3

Hi,

sorry i think you did not get me, I have a list of Report ID stored in excel a column, my problem is how do I get the first used cell in a column everyday?

for example below is the list of IDs:

ID NUMBERS

001
002
003
004
005
…

Today I need to use 001, tomorrow 002, and so on. I have a total of 5000 ID to use, so how do I make sure there is no duplication? Which VB method do I use to retrieve a new ID daily

4

@Zoe_1020
ok thanks for feedback