Here is an example of how to loop through an Excel file using the WorkSheet.Cells() property:


https://stackoverflow.com/questions/...names-by-index
https://docs.microsoft.com/en-us/off...orksheet.cells
Not sure what you are trying to do with the code you posted, as I would expect the primary key and its location would not change based on date and time timestamp.

Cheers,