View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Norville Jeff Norville is offline
external usenet poster
 
Posts: 7
Default copy application path to clipboard

I'm simplifying the way we shoot Excel files (and other office
documents) around our office.

Ideally I thought I'd just write a little macro tied to a button to
copy/paste the full document path to the clipboard where we'd paste
that into an email. Object model suggests something this method:
Workbook.ActiveWorkbook.FullNameURLEncoded

Unfortunately, FullNameURLEncoded gives the mapped drive instead of
the UNC - i.e., z:\work\file.xlsx instead of \\server\id\work
\file.xlsx.

Any suggestions on simple sharing full document paths with UNC?

And - a related annoyance - Office 2003 made it simple to include the
HTML path to the toolbar; anybody shed insight on adding Document
Location to the Quick Access Toolbar (as I've done through Word
Options Customize) through a macro?

Thanks,
Jeff