How to validate the user, and select the info

Closed
excelee
Posts
1
Registration date
Monday June 8, 2009
Status
Member
Last seen
June 9, 2009
- Jun 9, 2009 at 05:03 AM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- Jun 9, 2009 at 05:55 AM
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

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 9, 2009 at 05:55 AM
Hi
Put the code, the errors you are getting and the what is not working as intended
0