Share Workbook With "Allow Changes By Multiple Users" Code
Aug 8, 2007
Although i am using VBS, the coding should be similar. I am looking for all Excel files in a folder (WORKING) and determining if they are shared, allowmultipleusers, (WORKING). The problem I am encountering is changing the Excel workbook to a [SHARED] workbook. By that I mean Multiple users can open and make changes. What is the syntax to enable that? As an FYI I can save the [SHARED] workbooks as exclusive (normal), but not the reverse. I have tried Saveas,,,,,,xlshared, but is not working. Here is the VBS code I have (For grins)
Const APPLICATION_DATA = &H1a&
Set objShell = CreateObject("Shell.Application")
'Set objFolder = objShell.Namespace("L:Shared Services Stock Rotation ReviewRotations for Review")
Set objFolder = objShell.Namespace("C:Documents and Settingsmhast14DesktopRotations for Review")
Set objFolderItem = objFolder.Self
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objExcel = CreateObject("Excel.Application") ..............
I have a speadsheet, and at the moment, another spreadsheet access it via a vb code. but i have 3 - 5 agents needing it sometimes at the same time. All that happens, is the agents excel sheet passes some info to the server sheet, so the vb codes opens and closes it. So only one person can do it at the same time.. but i need this so anyone of the agents can enter info via the vb code.
When i tested it, it asked me when i opened it, if i wanted to save what the last person did, I need that not to come up, so really its like the sheet is always open, but not... and lines are added. The info is added to the same sheet, and line by line.
I have a workbook that I would like to share and allow multiple users to add and make changes at the same time. However, the workbook is full of macros that really need to run. Is this possible? The workbook is written in excel 2003.
If this is not possible then is it possible to share the workbook in a similar fashion but not allow any other users to make changes, but update their workbook with the changes that I make?
Is it possible to use the userform when it is protected and shared. I am able to access when it is protected. but unable to access when that protected worksheet is shared.runtime error message " unprotect method sheet class failed" appears it is shared and used.I have already raised this [b]issue in the forum.I understood from the answers that it is not possible.
" My requirement is multiple users should use the form and they should not have the access to edit the entires made by them"
Please give me a solution.
" Being a moderator myself i should only be able to edit or modify the entries made by the users."
Note: I dont want to create multiple excel sheets for multiple users.i want to use a single excel sheet (Shared and protected)
I have a large worksheet that for some reason I can’t share.
-It does not have any lists, that I know of, do not know how to see if there are any -It does have validation, but I have other workbooks with listed validation that are shareable -It is not protected -Does not have any named ranges -Is not read only -I have saved it as another file name and no luck there -I have copied the one sheet I really need into a separate file to try that it did not work,
My Workbook contains several UserForms in which employees will be entering hours and activities on a daily basis. In the UserForm, they select their department and enter hours for each specific type of work/activity that shows up for that department in the userform. They click the submit button and all the data (date, name, department, type of work and hours) is added to a database table in another sheet, which in turn feeds a number of reports.
I need to be able to have anywhere from 20 to 100+ employees enter their hours on a daily basis, many of them at the same time, all from different locations (within the network of the client's system), using the same UserForms.
We've experimented with Google Drive, but that seems not to be the solution. It kind of works, but is not secure (it installs a copy of the entire workbook on the users system and then synchs the data back to the server upon "save") and way too cumbersome. I've heard of SharePoint, but not every client has that installed (and frankly I don't know how it works).
I need to know that how can we share excel workbook. Is it possible over LAN? Also how many users can access the shared workbook. If 50 users are accessing shared workbook and each one working on different workbook. Is this scenario feasible? Will there be any issue if 50 users working on 50 different worksheets of same workbook?
I have a workbook which is used by over 100 people. It is turned on to share mode, but to ensure it would stay like that I need the workbook to check whether it is shared while being opened and then turn to share mode in case this would not be the fact.
I currently have a macro that can be used by multiple spreadsheets. Is there that I can execute the macro within any specific spreadsheet without saving it in each spreadsheet. I just want to place it in a general spot so that in case there is modifications, I only have to change it in one place.
I am running code that updates several excel sheets from a database, but quite often other users on the network are already in the sheets, is there a way i can remove the users just before the macro saves the file? Or alternatively saves it to the new filename whether or not someone is in it?
The code that I'm using is supposedly not allow spreadsheet to be opened after a certain date, or does not allow a user to press any of the command buttons and comes up with a message saying the spreadsheet is closed for new entries.But is not working for me.
I have a file I created which works fine for me, on my machine at least but there are two issues I'm trying to sort out.
The first issue is I need to share the file with others who may not have the same access rights. I have something loading in the Workbook_Open event which I want to bypass for users who do not have access to a specific folder. So I was trying to check their access using Dir(path) = "" at the top level folder to see if any files are present (which there are). My assumption was that if it finds files it's safe to assume they have permission and it's ok to continue, otherwise they don't in which case I want abort the rest of the code. This seems to work fine for me but I tried testing with someone I know does not have access and it gave her a compile error.
Part of the code in macro utilizes FileSystemObject which seems to be the line where the code bombs on my coworkers machine. The FSO seems related to appears related to the Microsoft Scripting Runtime reference, but it's not enabled on my machine or any of the others. I vaguely remember having to do something on my machine awhile back for the life of me don't remember what it was.
The second issue is an MS Forms error: "Could not load some objects because they are not available on this machine." appears when opening the file on three of the machines I tested but it does not appear on my machine. I've tried looking at the references and could not find any differences between the machines. I pored through various postings online and it appears it might be worth re-registering the DLL/OCX files but we need admin rights to do that so I will need to open a request with our support team.
I have an excel workbook that serves as a master workbook. I have to create 30 copies of this workbook, 1 for each site. Each workbook will have small differences in the data held. This is because I will refresh the sheet before saving it. There is a dropdown list on the 1st tab of the workbook that contains the names of the sites. The sequense, I suppose would be like: select the next name on the dropdown list"calculate" the spreadsheet to enable the refreshsome sort of "save-as" with the name from the dropdown list forming the name of the file. The Master file must be kept intact.select the next name from the dropdown listcalculate the sheet ........and so on I have a few other things I will add to the script like Protect Sheet etc.
I have a summary workbook that I want to save into different folders designated by the input from my userform. My directory has folders named: "A051 - Watson", "A052 - Gila Bend", "A065 - Tompkins"... etc; but I want to designate which folder to put the summary workbook in by the first 4 characters in the folder names(A051,A056,A055...etc) Let me know if I made it clear enough.
Modify Macro3 and use the InputBox function twice so that Macro3 would ask the user for a particular month and a particular year; and then Macro3 uses these user’s inputs to create the calendar template for that month of the year. For example, if the user enters February for the month and 2012 for the year, Macro3 would create a new
We have a Shared workbook on our Server and about 5 users work at the same time every day. I want to understand something, If I open it I can see all the information in it, all the rows and so on, but if the same workbook is opened by another user he will see other information, the rows aren't the same as in my case. Why does this happen ? I would like the second users to see the same information as I do.
I am working with a class module and some fields require specific inputs that another coder may not intuitively know. How can I create a list of acceptable conastants that will appear as a drop down when the user is coding with the custom object?
For example: I am creating an Email Engine object that will handle all my emailing needs in code, because coding emails is such a pain. Then I can just create the blasted thing, import the class module where needed and never have to worry about it again. Some coworkers are interested in using the module for their projects when I am finished. I want to put an option for message flags in the object, but only certain colored flags are allowed. How can I get the VBE to show a little drop down with the acceptable flag constants when another user types
[Object Variable].MessageFlagColor = {drop down list of options} I started with
Public Property Let MessageFlagColor(Value As Constants)
i have an excel database regarding about 1000 different schemes having the details of their initiation date, budget allocated , up to date expenditure, this month expenditure and many others too. this is a shared workbook and relevant officers enter their data in their relevant columns and rows. the file is shared. now i want that any changes done by mr. A, for eg. at record No. 09 could be intimated to Mr. B who is working at record No. 560. may be via msg box or any other source.
We have a place where all our documents are stored. We have a log where we all log in what we're working on. Our trouble is, if one person has it opened nobody else can add their items to it. Is there anyway to have multiple people be able to open and enter their work for the day, save and close it out?
I've created a model that uses an add-in to calculate otherwise cumbersome formulas, and 4 or so people need to access this model at any given time. It's saved (along with the add-in) in a public folder on our network drive. Everyone is able to access the model, and is able to load the add-in directly from that folder, but the cells that use the add-in point to where the add-in is stored locally on my drive (C:Documents and SettingsmeApplication DataMicrosoftAddIns) and thus they are not able to use the add-in functions without redirecting every reference to me with references to their add-ins (basically just by finding and replacing every 'me' with 'them' in those cells at this point). So I guess what I'm wondering is how do I make it so the add-in is 'universal' (instead of local) such that as long as each user has the add-in loaded they can fire up the model and use the needed functions.
I'm trying to identify a way of setting up a booking system for some meeting rooms we have at work. Always looking for a way of simplifying something that soaks up one of my colleagues time.
I read this post about a golf booking system and it looks like it could be adapted to suit, I can imagine a different worksheet for each room and the fields for entry on choosing the timeslot being the meeting title, who booked and a contact number and the slot showing the meeting name when hovered over possibly.
I noticed a similar thread about Outlook, I know nothing about this sort of stuff within Outlook and not sure it may be possible. I am just in my infancy with hyperlinks and macros and do not feel confident enough to start there as I do not know where to begin. Keen to learn and would love to figure out and play around within a program; learn best this way.
When saving a file, you get a popup with a suggested path. I need to find a macro that will either offer a suggested file name based on a cell's date value (a1) and a suggested path (to the desktop) for any user that uses the spreadsheet - or simply will save the file using the cell value as the name to the user's desktop.
Each user will have their own version of the file, to save to their own desktop. The macro will need to overcome the issues that each user's path to their desktop will be unique since each will have logged in to the window's session with their own profile.
I’ve thought up a workbook with four sheets named “Employees Summary”, “EMP001”, “EMP002”, “EMP003” and a number of customer account sheets. Customer account sheets are named by their account numbers.
Now for the hard part. I will have three employees. All of us will have to login to the workbook with a username and password. Usernames would be. Administrator, EMP001, EMP002, EMP003. You should be able to change your password at any time.
All sheets will be visible to the administrator. Employees will only be able to see their respective “EMP” sheet and "Employee Summary" sheet. the rest is hidden. And the really hard part Every employee will enter all their transactions for the day into their respective sheets....
