Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible?
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 " wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible?
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. On Jul 25, 1:56 am, challa prabhu wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible?
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 " wrote: 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. On Jul 25, 1:56 am, challa prabhu wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible?
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. On Jul 25, 5:30 am, challa prabhu wrote: 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 " wrote: 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. On Jul 25, 1:56 am, challa prabhu wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|