Multiple users updating excel spreadsheet dating site in all site de
In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one.
Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder.
Also, is there a way to pull out of Excel what is the current User's 'Options | General | Default File Location' entry? I am familiar with and use the following coding for Opening/Saving files to the current directory of the opened workbook, but it only gives the path of the existing Excel workbook and not the current User's Directory Path: Dim wb This As Workbook Set wb This = This Workbook Ch Dir wb This.
Path Hello, I have a number of different files that I often need to run a macro on.
Is there a way, perhaps through VBA, that I can not allow a user to save while somebody else is opening the document? My question is, can it be done with all users working at the same time and when saving their work all data entered will go to one master excel sheet?
People need to open the file to be able to sign up for various duty rosters.
MS Access is not an option for me so I was wondering if you could help me do this in excel.
thank you so much and would really appreciate to hear from anyone soon.
I have made an excel file where other people have to go in and update it. Found others suffering the same but haven't found any conclusive answer yet.
This process takes 2 secs but some people forget and stay in it over lunch etc causing a great annoyance. Im not concerned if they lose any data they've entered as I'm sure this will help them get the message to get out the file quicker.. Every so often when I attempt to save a file, (including save as), Excel won'r let me. Some days I can work without this problem, other days I encounter this 2 or 3 times.Our staff can't read and they keep opening additional copies of the file!