user authentication and filter copy and update the data

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("USERNAME")

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- Checks for the values from step 4 in column A of sheet "data"
7- Retrieve all the matching value rows info into the current workbook (where macro is running from)
8- close all other workbooks
9- let user updates the rows info
10- Update the main.xls with modified information by clicking a button
11- Create a log in event_log.xls stating the user_Id, Date, time and row names that are upadated

I have already coded this, but it is scattered with many errors and not working. I appriciate any help towards this.

re: user authentication and filter copy and update the data

Welcome to Bytes!

I hope you find all the answers your looking for in the Access Answers Forum

-Frinny

re: user authentication and filter copy and update the data

1. This is a mighty tall order, excelee, but first, where exactly are you running this code from? (Access or Excel).
2. Are you using Automation to read the Excel Spreadsheets, if executed within Access?