How to open a document placed in an Eroom on intranet in VBA

  • Thread starter Thread starter Christer
  • Start date Start date
C

Christer

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)
 
Back
Top