Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename attachment
How do I rename multiple attachments when stripping
multiple attachments? I have the code to strip attachments and it works fine. My problem stems from file names that include forward /'s. Example below: /company/operations/filename So actually, I need to keep filename, but remove preceding information. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename attachment
You can use the InstrRev function to find the last slash, or the Split command to split the
string at the slashes and discard all but the last element in the resulting array. On Fri, 18 Jul 2003 07:48:27 -0700, "Andrew" wrote: How do I rename multiple attachments when stripping multiple attachments? I have the code to strip attachments and it works fine. My problem stems from file names that include forward /'s. Example below: /company/operations/filename So actually, I need to keep filename, but remove preceding information. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rename | Excel Discussion (Misc queries) | |||
how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
why can't I rename my worksheet? | Excel Discussion (Misc queries) | |||
Rename Add-Ins | Excel Discussion (Misc queries) | |||
Add Sheets and rename | Excel Discussion (Misc queries) |