Posts1Registration dateMonday June 8, 2009StatusMemberLast seenJune 9, 2009
Jun 9, 2009 at 05:03 AM
Posts261Registration dateSaturday April 11, 2009StatusMemberLast seenJune 21, 2011
Jun 9, 2009 at 05:55 AM
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.