I have several people entering information in a shared file and we keep
running into conflicts when saving data - so, I want to put something
together in a macro that will save, close and re-open the file after each
entry to keep the info fresh. Is this do-able? What are my options!?

Maybe you could provide a little more info. Before you go too far down that
road, though, I'll say this... I worked with shared workbooks, and embedded
with lots of code, for about 9 months. Headache beyond belief!! Very erratic;
some weeks we had no problems and some weeks we had nothing but problems. I
think the Help menu says that the max. number of users for shared workbooks
is 255, but in my
experience it is much, much, much less and it really depends on the size of
the file.

As you may expect, the smaller the file, the better the performance.

Without making the file a Shared Workbook, there is no way you will be able
to let multiple users access the file simultaneously.

I would say, try to avoid doing this in Excel, at all costs.
As an alternative, Access should work quite well in the scenario you
described. Actually, this would be a piece of cake for Access. You are
setting yourself up for major disappointment if you try to make Excel do this

Good luck,
Ryan€”


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"posheroff" wrote:

I have several people entering information in a shared file and we keep
running into conflicts when saving data - so, I want to put something
together in a macro that will save, close and re-open the file after each
entry to keep the info fresh. Is this do-able? What are my options!?