Multiple users updating excel spreadsheet dating site in all site de


13-Aug-2020 16:13

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!



And so Tinder in Ukraine is nothing like the Tinder you know.… continue reading »


Read more

TCC reserves the right to immediately suspend or terminate your access to TCC service, without any prior notice, upon any breach of this Agreement by you which is brought or comes to TCC's attention.… continue reading »


Read more

Here's the latest on what the star's been up to and whether she is set to get hitched once more to her latest beau...… continue reading »


Read more

Aspiring members have to pass a 48-hour peer vote to be accepted as one of the ‘beautiful people’.… continue reading »


Read more

As we have already mentioned, the institution of family is very strong in Japan, and every girl in this country wants to start a good family with a responsible man she and her future children can rely on.… continue reading »


Read more