View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Excel Workbook Address in VBA

Hi Donald,

Is it possible to get the web address of an Excel workbook using VBA.
The only address I can find in the VBA help refer to cell addresses,
or to the outlook address book.

The string I am looking for is that displayed in the 'address' field
of the 'web' toolbar.


AFAIK, you can use ThisWorkbook.FullName, which should return the full URL
(Path/Filename) of the workbook.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]