If the users have a drive mapped to the network share, they can open
the workbook using that drive:

Workbook.Open "M:\Folder\Book1.xls"

If security policy allows direct access to the network share, you can
use

Workbooks.Open "\\ServerName\ShareName\Folder\Book1.xls"

Beyond that, there isn't much to it.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sun, 30 Nov 2008 08:57:01 -0800, Li Jianyong
wrote:

Hello,Sirs

Please let me know how can I realize networking through VBA excel. I want
to put an workbook in a server and let my colleagues to read,write ... this
workbook through Networking.

Please give me suggestion how to...

Best regards