How to validate the user, and select the info

[Closed]
Report
Posts
1
Registration date
Monday June 8, 2009
Status
Member
Last seen
June 9, 2009
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I 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.

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi
Put the code, the errors you are getting and the what is not working as intended