How can a workbook grant access to another one

Hi everyone,
I'm looking to solve how a workook can grant access to another one.
Here more details:

I have a template, let call it "BuildID.xlt", which will allow users
to know how a specific ID shall be built based on some criterias. In
some specific cases, an ID can't be built based with the provided
criterias and for this, I would like to built a credential internal
ID, like INT1, INT2, INT3 and so on.
The internal ID has to be unique.

For this, I have created a central protected workbook, let's call it
"CentralID.xls" where the last ID used will be stored.
This workbook has 3 user profiles: 1. "Automated Access", 2.
"Specialist", 3. "Other".
Profile "Other" will open the workbook in read only mode (the profile
will be provided in a userform).
Profile "Specialist" will open the wb in read-write mode, in order to
allow to do manual corrections (again, profile provided from a
userform).
Profile "Automated Access" is reserved when the "BuildID.xlt" accesses
the "CentralID.xls".

How can I pass the profile from the "BuildID.xlt" to "CentralID.xls" ?

At the same time, if 2 users try to access the "CentralID.xls" at the
same time, User1 will block the workbook. The module triggered by
User2 will try every 2 seconds to access the same workbook. As soon as
User1 has finished, User2 will be allowed to access the workbook.
Futhermore, if the "CentralID.xls" is used by the profile
"Specialist", other users will get a corresponding message that
"CentralID.xls" is not available at the moment.

How is it possible to manage the information flow between the 2
workbooks ?

Thanks a lot for any help !
Joel
0
jo77
2/23/2010 6:41:17 PM
excel.programming 6508 articles. 2 followers. Follow

0 Replies
556 Views

Similar Articles

[PageSpeed] 45

Reply:

Similar Artilces:

how can i change my email address outgoing.
Ok, I have an email address which is 'piggy backed' to my normal email address so that anything from work comes through to my outllook account. When i receive mail it comes through as being sent to it ok. My question is how can i set it up so that my personal email doesn't show up on outgoing mail but shows as my business mail address thus looking more professional.? me2130 wrote: > Ok, I have an email address which is 'piggy backed' to my normal email > address so that anything from work comes through to my outllook account. > When i receiv...

new to access
i am fairly new to access 2003, i have created several database, very basic ones, and i am trying to learn how i can enter information in one data base and have it distributed into the rest of them. i manage 4 buildings for a school, ihave one database for each building and i have to enter what rooms i put students in, ihave another database for new arrivals, once there entered in new arrival data base, i then have to enter them in to the proper building, i have one for students checking out, once enterd in the checkout database i have to go into that buildings database and remove them. this i...

Why Users can open other users folders
Hi We have Exchange Server 2003 and we access Outlook using exhcnage server. I have found that all users can access others folder by going File, Open, Other User's Folder. Can you please guide me how can I prevent this. Do I have to make permission changes on Exchange Server? If yes where? Your prompt response is greatly appreciated. mukeshhtrivedi@gmail.com wrote: > Hi We have Exchange Server 2003 and we access Outlook using exhcnage > server. I have found that all users can access others folder by going > File, Open, Other User's Folder. Can you please guide me how can I ...

Can't find LDAP Directory Server for sending my mail
I am using my Outlook a lot. Have many contacts in my outlook system. When I like to look them up as a list, I get "Cant find LAPD directory server (81). My address book is not listing all the contacts that I have emailed to. Hope that you can help. Arthur Grin agrin <agrin@discussions.microsoft.com> wrote: > I am using my Outlook a lot. Have many contacts in my outlook system. > When I like to look them up as a list, I get "Cant find LAPD > directory server (81). My address book is not listing all the > contacts that I have emailed to. Hope that you can help. ...

how can I find and download a WAB DLL file for Outlook 2000
When trying to use outlook I get a error message "cannot find WAB DLL" I may have accidently removed it. What OS are you using? Curious since OL2000 isn't Vista compatible. "JEJE" <JEJE@discussions.microsoft.com> wrote in message news:E344280E-7FEC-4550-8255-E1069D4A8621@microsoft.com... > When trying to use outlook I get a error message "cannot find WAB DLL" I > may > have accidently removed it. if you are using vista, see http://www.outlook-tips.net/howto/vista_wab.htm otherwise, we need to know the version of windows. -- Diane Po...

Entourage 13.0.4
Users are crying out about this. On Entourage 13.0.4 with Exchange 2010 meeting invites are showing up wrong only in the "When:" field of the Preview Pane. On their calendar and the rest of the preview pane the time is correct. We are eastern standard time (which entourage says is GMT-4:00 but the OWA says GMT-5:00 and so does their date & time preferences). Is there a fix for this? I can provide a screen shot if someone needs it (and if the news forum allows uploading [which I doubt it does]) On 2010-03-18 14:39:10 -0400, Nathaniel said: > On Entoura...

how do I copy several lines of word text into one excel cell?
In a word doc I need to copy several lines of text and paste them into one excel cell. I can't seem to find any help telling me how to do this (each line pastes into a different cell) You can either double click the cell or press F2 key to get into edit mode for the cell, then the text pasted would all go into the cell. -Simon "jhh" wrote: > In a word doc I need to copy several lines of text and paste them into one > excel cell. I can't seem to find any help telling me how to do this (each > line pastes into a different cell) thank you SO much Simon CC - ...

curly quotes became straight, can't get curly bakc
something changed curly quotes to straight, and now I can't resume curly quotes. I assume you've already checked your AutoCorrect options to make sure replace straight quotes with curly quotes is checked, so let's look at the other simple fixes first. Have you recently changed to a new font? Some fonts don't support curly quotes. What version of Word are you using? Jerry "John Worsley Simpson" wrote: > something changed curly quotes to straight, and now I can't resume curly > quotes. And in some fonts it's really hard to recogni...

Cannot access certain website
I have no problem surfing internet. But i cannot access only www.ofs.edu.sg in the office. At home no problem. How to troubleshoot such problem? "2Sweet" <chongcmw@hotmail.com> wrote in message news:#rMwh#$zKHA.1236@TK2MSFTNGP06.phx.gbl... > I have no problem surfing internet. But i cannot access only > www.ofs.edu.sg in the office. At home no problem. > How to troubleshoot such problem? Refine your symptom description. What does "cannot access" mean? What do you see? FWIW I got a black clock in the Status bar and was imagini...

Define a specific Printer using VBA (Access 2000)
Hello, I am using Access 2000. (No way to change Access version for now) I know that In Access XP can be done this request. I Would like to print to a specific Printer when I open a report in NormalView without changing the default printer (I know how to reset default Printer using VBA. There is an option in PageSetup of every report "Print to a specific printer" but I would like this option to be set for every report by VBA. I thank you in Advance Kon. ...

Access 2007
Hello All, I just installed Access 2007 and have noticed that I can not scroll through records using the mouse scroll button whereas in the previous version it was possible. Is there anywhere you need to activate this or could this be a problem somewhere? Will appreciate any feedback Thanks and Regards Fakhruddin Zavery See: Scroll records with the mouse wheel in Access 2007 at: http://allenbrowne.com/ser-70.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps...

Combining two fields into one in a query for a report
The database I am working on is to keep track of parts that are either in their storage area (on a shelf) or on an assembly line. I have two fields, one called Shelf and every part has a shelf assigned to it. The other field is Line and if a part in on an assembly line, there is a number indicating that line, if the part is on it's shelf, the word STOCK appears in the line field. (Has to be this way for the rest of the database to work, so this is not up for question) Now, I need to creat a report to show where all parts are. If they are on a line the result needs to show the l...

after XP-SP2 problems with Outlook Web Access
After XP-SP2 Outlook Web Access reacts strange: If I trie to answer to an email the answer windows (form) hasn't any text field. I already added the Web-Site to trusted sites - but nothing changed. Any ideas? Resetted all the Internet Explorer options and Zone Settings, Cleared the Temporary Internet Files, etc already? If so state your version of OWA and ask in an Exchange newsgroup as OWA is part of Exchange not Outlook. -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service...

Using Access 2003 Run-Time Version
I am trying to use the Access 2003 run-time and almost everything seems to be working just fine. I have noticed however that I seemed to have lost the ability to right click on a report and bring up the options of print/email.... When I right click using the run-time versionm nothing displays (as if the right button is disabled). When I right click using the regular mdb (full access 2003) all the options appear and I am able to print/email/etc at this time. My main question is is there any way to get the right click options back in a run-time version. Thanks That's correct: the run...

Can't Print Money 2004 Report
Can some kind soul please tell me how to print a year end report on Money 2004, listing All transactions by payees and all deposits. Thanks Ray In microsoft.public.money, R wrote: >Can some kind soul please tell me how to print a year end report on Money >2004, listing All transactions by payees and all deposits. I would start with the Account Transactions report. Customize, checking each tab for your preferences. In particular, on the Rows&Columns tab, I would select to SubtotalBy:Payee. Set the Date to Previous Year. You can sort by clicking column headings. To print, right-...

Tabs not visible for one user
I have a worksheet with 12 tabs that is stored on a shared drive, this is accessed by several users. One user is not able to see the tabs across the bottom. She is at a different location than all other users, so we can't physically see this on her PC. All other users can see the tabs when accessing on the shared drive, and when opening an emailed copy. We have had her maximize, etc. and still no tabs. Any suggestions on what I can tell her. I might be missing something simple. I have tried to recreate the problem on a local copy, but can not. Thanks Have you checked the obvious...

Combine multiple workbooks into one workbook
I would like to combine a number of workbooks inside a folder into one workbook and maybe have the worksheet name be the name of the file or something. The core issue is combining them. I have looked and I see how to reverse it but not this exact thing, please help. ...

template in a shared workbook
When I attempt to insert a template worksheet into a shared workbook I get the error that This command is not allowed on a shared workbook. It will allow me to insert a blank worksheet into the same shared workbook. Excel 2000. My template folder is configured through WORD to be on the network drive so it does appear as an option to insert it into the workbook. Thank you for your help. ...

Setting Value Of One Cell Equal To Value Of Selected Cell
Without using VBA - If cell A1=red, A2=white and A3=blue, can I set C1 to be the value of the selected cell so that if A1 is selected, C1 will equal red, if A2 is selected, C1 will equal white, etc.? Thanks, Sheldon Potolsky Sheldon, In a word, no. No worksheet thing comes to mind that works as a function of the active cell. You might want to use some radio buttons or a list box (Forms Toobar or Control Toolbox) instead of cell selection. They'll let you click to make such choices, and you can use formulas that will change a cell value as you wish. -- Regards from Virginia Beach, ...

Macro to remove contents of cell and move all other contents up one row
I've very lillte or no experience of macros and got some very usefu help from a kind user of this forum a couple of days back and I'm bac looking for more help. Its a bit long winded but here goes. I need a macro which checks the contents of a couple of ranges o cells, starting with the first range of cells lets say it checks cell A4,B4,C4,D4 down to cells A20,B20,C20,D20. Now if for example cell A7,B7,C7 and D7 have values (note the formulas used in these cell means that if A7 has a value then B7,C7 and D7 will also have a valu if A7 is blank then B7,C7, and D7 will be blank) and no...

In excel can you select certain cells which contain the same text
If I have several cells with the same text in them can I filter these out and select them. I know you can do this for formula etc but can it be done for text? try data>filter>autofilter -- Don Guillett SalesAid Software donaldb@281.com "ade" <ade@discussions.microsoft.com> wrote in message news:937AD9E1-668B-4E32-B194-29146DF0A60A@microsoft.com... > If I have several cells with the same text in them can I filter these out and > select them. I know you can do this for formula etc but can it be done for > text? ...

Turn 'On' or 'Off' 'Subtotal' in Access PivotTable Forms
Hi All This is my first time here and am hoping for some assistance. I have an access pivot table in a form and I am able to insert/remove totals and fields in the pivot table. However I am not able to turn 'On' or 'Off' the 'Subtotal' on either the column or row fieldssets using code (ie VBA). Has any one come accross this issue? Any suggestions? Thanks so much Ram ...

Outlook 2003
If someone sends me several pictures they dont automatically display one above the other like they used to in OE before i upgraded to Outlook 2003? I can find the bit about automatically downloading pictures but those are for HTML emails - i want them to display if they are sent as attachments! driving me mad and wasting lots of clicks and time! help please!! thanks Not possible. And note that you didn't upgrade but are using a completely different program now ;-) -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Creating Signatures -Create an Office XP CD...

You can use Google Maps with an Acess DB
How to open a Google Maps showing a location from your database. Not sure if anyone is interested but it was asked a couple of days ago and I didn’t know a good answer - just in case you have looked at my 1st attempt :-) so I looked into it and came up with this. There will be other methods – so this is just one. To open Google Maps with the pointer placed on any location in your database. Notes: I assume you have a field called PostCode – if not then change the OnClick. The field must contain a real postcode (the link will fail if the postcode does not exist) This will work for anywh...

NEWBIE to ACCESS help with forms
Hi, I am looking to have a form, With 1 combo boxes (telephone), and the rest text boxes. I want to be able to select a telephone number and have the other 2 boxes shows the associated firstname and last name so for example.. I have a table with 3 fields telephone first name last name Additionally IF POSSIBLE would want to be able to choose a last name, and it show the telephone and first name associated Access 2003 Thanks in advance When you create a combo box using the wizard, it gives you two options: Save the combo box selection to a field or Look up a record using the combo ...