Excel Workbook for Multi User Access

[shahzad4u_ksa]

Hi,

I want to prepare VBA Application for the Multi users with different
rights. how to prepare it.?

I want to know what is the Excel workbook Limitations, I mean If the
workbook goes to 5 MB OR 10 MB then what will happen. with the
database it effect the speed .... or what.

I want to use one workbook for 3 users at one time it is possible ?

Pls provide me the information regarding the above 3 questions.

Thanks in Advance.



Syed shahzad zafar
Madinah - KSA.

 

[Mike Fogleman]

For multi users you would want a Shared workbook (Tools-Share Workbook) and
save it to a public drive accessible by all users. VBA will not run in
shared mode, but it will display the results of macros that are ran in
normal mode. In-cell changes can be made in shared mode for all to see. In
order to update a shared workbook with macros it would need to be opened by
one person only (probably the owner), unshare the workbook, run your macros,
then set workbook to Share again, and save it back to the public drive.

As far as workbook size and speed, obviously bigger is slower. The
limitations are governed by the computer that is opening the workbook, CPU,
RAM, network MBps, etc. A computer running WindowsXP, Excel 2003, dual core
CPU and 2 G of ram should have no problem with a 30 MB file.

Mike F

 

[Dave Patrick]

Hard to say without more detail but Access may suit your needs better.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect