Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application Path | Excel Programming | |||
function: copy current path or filename to clipboard (XLS) | Excel Programming | |||
Excel <- Application clipboard data transfer | Excel Programming | |||
set path for Application.Run | Excel Programming | |||
Application.Path | Excel Programming |