Thread: How to open a document placed in an Eroom on intranet in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How to open a document placed in an Eroom on intranet in VBA
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
Reply With QuoteReply With Quote