Networking by VBA
 

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

Networking by VBA
 

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

Networking by VBA
 

Excuse me for this intervention but if A open the workbook on a net share B
and/or C can open it at the same time too? Aren't there problem of
syncronization, consistency and other like those indicated in ACID property
of a database?
Thank you in advance.

Nicola M.

"Chip Pearson" wrote:

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

Networking by VBA
 

Is it possible to keep an excel based database on a server and access it
through VBA from another workbook via the internet? I am sure I should
probably be using Microsoft Access for this sort of thing. But for now is
this possible with Excel VBA?

"Chip Pearson" wrote:

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