ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Rename attachment (https://www.excelbanter.com/excel-programming/272029-rename-attachment.html)

Andrew[_15_]

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.

Myrna Larson[_2_]

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.




All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com