I have a document placed in an Eroom in the Intranet. Is it possible to open
that document within Excel VBA? How do I set the adress to the document?

/Christer

If the share that contains the workbook is on a mapped drive, just use
that drive letter:

Application.Workbooks.Open ("M:\Folder\Folder\Book1.xls")

If you have a server and share name, use something like:

Application.Workbooks.Open ("\\Server\Share\Folder\Book1.xls")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 18 Sep 2009 07:05:02 -0700, Christer
wrote:

I have a document placed in an Eroom in the Intranet. Is it possible to open
that document within Excel VBA? How do I set the adress to the document?

/Christer