There are many Simple Solutions
1)this will generate a unique number appened this number with all your fields which will make it unique
2)another simple idea would be keep a flat file for example txt file with the content "1"
you read this file and appened 1 with all your data once you read add 1 to this value and rewrite the file using VBFSO
3)or just create a excel sheet with unique values in a single column.
Every time your read the first cell after reading delete the value and save the file
that way when you read again you will have a unique value...
Hope this helps
1)this will generate a unique number appened this number with all your fields which will make it unique
2)another simple idea would be keep a flat file for example txt file with the content "1"
you read this file and appened 1 with all your data once you read add 1 to this value and rewrite the file using VBFSO
3)or just create a excel sheet with unique values in a single column.
Every time your read the first cell after reading delete the value and save the file
that way when you read again you will have a unique value...
Hope this helps
