want to run a script to first identify the user, and after identifying the user opens a workbook (e.g. workbbok1, sheet1).
user_ID = Environ("USERNA ME")
the following is the process
2- Opens the workbook users.xls
3- Check if user_ID is occurred anywhere in column B-E of "Sheet 1"
4- If so extracts the value of A for each instance
5- Opens the workbook main.xls.
6-...