Hi Subha,
Please try the below solutions and see if it works for you..
Solution #1:
Change the Customer Name in the data table every time before executing the script. But it might be operationally tedious.
Solution #2:
Programmatically we can do this using the Solution #2.
Note: In this code, you will get a unique name every time you run the script. It will have 19 characters.
Let me know if any queries.
'Code Starts Here
'Code Ends Here
Thanks and Regards,
Swami
Please try the below solutions and see if it works for you..
Solution #1:
Change the Customer Name in the data table every time before executing the script. But it might be operationally tedious.
Solution #2:
Programmatically we can do this using the Solution #2.
Note: In this code, you will get a unique name every time you run the script. It will have 19 characters.
Let me know if any queries.
'Code Starts Here
Code:
Dim ReqMonth,ReqDay,ReqYear,ReqHour,ReqMin,ReqSec,CustomerName
ReqMonth = Right("0" & DatePart("m",Date()), 2)
ReqDay = Right("0" & DatePart("d",Date()), 2)
ReqYear = DatePart("yyyy",Date())
ReqHour = Right("0" & DatePart("h",Time()), 2)
ReqMin = Right("0" & DatePart("n",Time()), 2)
ReqSec =Right("0" & DatePart("s",Time()), 2)
CustomerName = "Subha" & ReqYear & ReqMonth & ReqDay & ReqHour & ReqMin & ReqSecThanks and Regards,
Swami