Share The Workbook With A Number Of Users
Apr 3, 2009I have a workbook, that has a lot of VBA code, & Userforms. I need to be able to share the workbook with a number of users.
View 13 Replies
ADVERTISEMENT
Share Workbook With "Allow Changes By Multiple Users" Code
Aug 8, 2007Although 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") ..............
How To Share Macro(s) To Other Users So They Can Use It
Jan 7, 2014How do I share a macro(s) to other users so they can use it? Each user has different location because we are working remotely.
View 1 Replies View RelatedShare Spreadsheet With Multiple Users
Sep 11, 2007I 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.
Share Workbook Option Disabled – Can’t Share Workbook
Mar 26, 2008I 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,
Share With Multiple Users Allowing Macros
Oct 9, 2008I 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?
Access An Userform For Multiple Users With "protect And Share Option"
Apr 27, 2009Is 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)
Also provide me an alterante solutions if any
How To Access A Share Workbook
Jun 12, 2014I 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?
View 2 Replies View RelatedHow To Share Workbook With Tables
Feb 3, 2011I have a workbook full of tables and pivot tables. When I try to share it tells me to convert the tables to ranges or to something about XML.
View 6 Replies View RelatedShare Workbook While Openning It
Sep 17, 2006I 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.
View 4 Replies View RelatedUsing Workbook By More Than One Users At Same Time
Jan 8, 2012can we use excel workbook by many users at same time ?.
View 3 Replies View RelatedRemoving Users When Saving Workbook
Aug 2, 2006I 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?
View 4 Replies View RelatedUse Vba To Create Copies Of Excel Workbook For Different Users?
Nov 26, 2012I 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.
View 1 Replies View RelatedSave Workbook To Folder Chosen By Users
Aug 16, 2007I 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.
View 4 Replies View RelatedUserform With Access Of N Number Of Users
Mar 20, 2014I need a Userform for employee reports which should be accessible for everyone without any struck.If employees update their updates in that form it should be stored in the centralized Data base.Finally the data collection team will take the reports and updates from data base.
View 1 Replies View RelatedShared Excel Workbook Shows Different Information For Users
Mar 3, 2014We 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.
View 1 Replies View RelatedSharing Workbook With Multiple Users Entering Data Simultaneously
Feb 2, 2013My 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).
How To Intimate Other Users About Editing Record In Shared Excel Workbook
Jun 2, 2014i 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.
View 1 Replies View RelatedUnique Count Number Of Users In Month Regardless Their Frequency
May 29, 2014I have a signup record that expected to grow up to row 400. On the top, there's a monthly tally for reports. Column B to count the number of boxes taken and Column C for the users picked up the boxes.
Users should be accounted as one appearence in a month, regardless re-appearance in the same month or different month.
I haven't found the generic formula to uniquely count the number of users regardless their frequency in a month.
NOTE: Timings, box numbering format and usenames are randomly generated. Any similarities with real subjects will be coincidence only.
Use One Template To Enter Data With Users Being Able To Start Entry From A Number Of Different Starting Points
Jul 30, 2009We're trying to use one template to enter data with users being able to start entry from a number of different starting points. this changes they way the look-ups have to work. The attached sample explains it a whole lot better.
View 2 Replies View RelatedExcel 2003 :: Unable To Allow Users To Make Changes To Workbook But Only Be Able To Do Save As Not Save
Dec 3, 2012I have an expense report, which was originally done in Excel 2003. It still prompts users to open as read only however if they select no, they are not prompted for the password, and it has allowed them to save, so when the next person opens it, they have the previous person's report instead of the clean workbook. I have tried everything to put a password onto it. I know this is really basic stuff, but maybe I am missing a step? I want the end user to be able to make all the changes they want in read only mode and then do a save as, but if the select No when prompted "Open as Read-only?" they should have to put a password in.
View 4 Replies View RelatedHow To Share Codes
Apr 1, 2008I have written a VBA code.
I thought I could just save it as an ADD-IN and then have my colleagues to add it, but that does not work. The macro will be stored in a seperate workbook and that is not what I want. I want them to be able to open any workbook and want them to be able to run the macro. I.e. everytime they open a workbook the macro should be available and be ready to run.
Share Excel In The Company?
Aug 14, 2014My company has a lot of file excel. I usually use Google driver, LAN and a lot of the other ways to share file to all member in the company. But so, it is time consuming very much and not protect information in my execl file.
View 5 Replies View RelatedUse Excel In Share Mode?
Jan 3, 2013We have a spreadsheet at work that is saved as Micosoft.xlsx [share].
I think the "[share]" means that more than one person can access it at the same time. How do you create a document like this.
Code To Turn Share On/off
Aug 28, 2007Need code to disable and enable "Protect and Share Workbook"?
View 9 Replies View RelatedLoop Through Files On Share
May 30, 2008I have the following code, and it is working well for one file. I'm trying to figure out how to do a loop to go through each region folder and update, save, and close each file just like the code below is doing for one file.
There are 10 region folders
Each region folder contains 8 or fewer files.
Please see the sample code below for the sample file location.
Sub TrendByRegion()
Application.EnableCancelKey = xlDisabled
Set wbOpen = Workbooks.Open(Filename:= _
"S:High Level ShareReportsReports by RegionPivot Table Files
Region 1Catalog File.xls")
wbOpen.RefreshAll
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
File Not Share Due To Tabs Or XML Maps
Jul 3, 2014I have an excel document that I wish to share for multiple users to edit, but get the following error message Excel tabs or XML maps.
View 3 Replies View RelatedDocument Saved On Network Share?
Feb 27, 2013My coworkers and I use a couple of Excel documents to store statistics. The document is on a network share. We all have Office 2010, my coworkers are on Windows XP, I am on Windows 7.
If I open the document and make changes, then save it to the network location I can open the document later and see the changes but my coworkers do not see any changes I have made. Also If my coworkers make changes to the document the 3 of them see the changes but I do not.
If I go straight to the network share the timestamp on the document only changes for changes I made.For example if I go to servernamefoldernamestats.xls and add data to the file. Then save and close it. I can reopen the file and my changes are there.
Tomorrow Coworker 2 opens the same file from the same location but it has data from 2 days ago, with a timestamp of 2 days ago and my data is missing. They then reimput the data I entered, and add todays data. Then they save it and close.I open the file it has my data from yesterday, but not the new data entered by coworker 2.
Share A Toolbar That Calls Macro From An Add-in
Mar 14, 2008I have created some macros that need to be used in several workbooks by more than one users, so I put them in an add-in and gave them instructions on how to get the add-in. I also created a toolbar with buttons calling those macros, attached it to a workbook the users can open, and instructed them to open that workbook once to get the toolbar.
Both the add-in and the toolbar workbook are on a network drive that my users can access, but when they get the add-in, it gets copied to their own add-in folder.
Here's my problem:
When a user tries to click on one of the buttons in the toolbar, the button tries to call the macro using the path that would be valid on my computer to get to my add-in folder. This path includes my user name, so it doesn't go to their own add-in folder: it goes to my add-in folder on that computer if I ever logged in on that particular machine, or it goes nowhere.
When I created the button, I attached the macros by referring to the add-in workbook by name only, without referring to a path, so I don't know why MY path ended up defined on that toolbar.
How can I go around this? I manually relinked all the buttons for that user, and I can do it for the other users (there aren't that many users nor that many buttons), but I'd rather avoid it: I'll have to re-do it if the toolbar is updated and it just seems like more work than should be necessary.
I'm also opened to suggestions on a better way to share those macros. They can't be attached to the workbooks because we use new workbooks every year - they're emailed to us by the people who create them and for a variety of reasons, pasting everything into a workbook of our own is not a good option.
Multiple Spreadsheets Share The Same Macro
Feb 3, 2010I 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.
View 14 Replies View Related