Is this possible?

[adam_kroger]

I have been constructing a Workbook that will be used by 13 employees
to record their daily activities in 28 catagories and an "Other" This
data wil be available in several diferrent reporting tools. Each
employee has their own password protected worksheet to enter their
data on (sheets xlVeryHidden otherwise). Most of my co-workers are
not evry computer literate, and at the end of the day there would be a
bit of crowdinng as everyone tried to get access to teh Workbook. I
was wondering if something like the followinng would be possible.

Construct a second workbook that would be pretty much nothing but
userforms. When the Workbook opens, a logon form would then pass
access to a userform that the employee could keep open all day, or
just use at the end of the day that would then parr the information
over to the "Master" workbook and enter the data in it automatically.
The UserForm workbook would need to be able to pull information from,
and puch innformation to the Master workbook silently. Can this be
done, and on a scale of 1 to 10 how hard/inefficient would it be?

 

[Guest]

Hi,

For mor information please refer to the following URL:

1. http://www.contextures.com/xlDataVal02.html
2. http://www.contextures.com/xlorderForm01.html

Challa Prabhu

 

[adam_kroger]

Thank you for your response, I use data validation and dropdown lists
quite extensively in the WorkBook. My question was about if it is
possible to change information in an Excel WorkBook, from a userform
that is in a different WorkBook.

 

[Guest]

Hi,

Yes. Using VBA in Excel, you can perform this task. You have to be specific
about the Path of the Workbook location and the adsolute address of the cell
location in the worksheet of that workbook.

Challa prabhu

 

[adam_kroger]

You used the term "Absolute Address" and I am not familiar with it.

If I want to change the data That is in the Cell "A1" in WorkSheet
"Sheet1" of WorkBook "Test.xls" located at "C:\TestCase\Test.xls" to
match that which is contained in the variable "MyVariable" from a
userform located in the WorkBook "D:\UserForms.xls"

Secondly, when the userform is placing the data into the other
workbook, can Excel do so without visually opening the second
workbook? Also, can it automatically save the changes that were made
to the second Workbook then close it again? I only want the second
WorkBooks file to be locked to a particular user during the writing
(or reading) of the data to/from that WorkBook.