Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email using universal naming convention
Yes. This is how I have to send out my links. What's happening is that the
drive letter assigned during the drive mapping process on your computer may differ from that assigned on theirs. To use the UNC, just precede with the word file, and use forward slashes vs backward slashes like so: ='file://myserver/subdir0/subdir1/subdir2/subdir3/filename.xls'!$H$2 Hope this helps! Ken Lawson "Sandy" wrote in message ... When emailing Excel spreadsheets, sometimes the drive letter changes unexpectedly, i.e. from F to G. Would code using a universal naming convention (UNC) work? If so, what would be an example of how to code it? Is there something else that might be causing this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use a function to implement a naming convention? | Excel Worksheet Functions | |||
modified following business day convention | Excel Worksheet Functions | |||
Naming convention for workbook names | Excel Discussion (Misc queries) | |||
Convert stored numbers into a set naming convention | Excel Worksheet Functions | |||
Email using universal naming convention | Excel Programming |