By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,479 Members | 1,622 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,479 IT Pros & Developers. It's quick & easy.

user authentication and filter copy and update the data

P: 1
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.
Jun 9 '09 #1
Share this Question
Share on Google+
2 Replies


Frinavale
Expert Mod 5K+
P: 9,731
Welcome to Bytes!

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

-Frinny
Jun 16 '09 #2

ADezii
Expert 5K+
P: 8,679
  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?
Jun 16 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.