I have some two thousands rows in Excel in following format :
NameID
Dejan 8082
Bernard 8317
Will 8349
.
.
I would like to create some hyperlinks at all IDs so that once I click any of them, the ID and the corresponding Name will be passed as arguments to the following batch file.
echo
echo Dear %1,
echo Your ID which is %2 has been locked.
I can call a batch file through hyperlink but seems passing argument in it is invalid.
I suspect some Visual Basic coding is needed. Can anyone help ?
更新1:
Sorry. The original table above depicts the format incorrectly. All the names should be in column "A" and IDs should be in column "B". Something like the following : |___A___|___B__| |_______|_______| |_Name_|___ID__| |__Joe__|__1567_| |__Ada__|____17_| |__Ben__|____32_|