Re: Extract file name
You can use this array-entered** formula to do that...
=MID(A1,MAX((MID(A1,ROW(1:260),1)="\")*ROW(1:260))+1,260)
** Commit this formula with Ctrl+Shift+Enter, not just Enter by itself
Rick
Wouldn't it be better to use ROW($1:$260), so you can fill down without
changing the reference?
Yes, of course. I actually had that in my original test formulas, but some
error happened in it and, after I corrected it, I didn't notice that Excel
had removed the $ signs from the equation.
Rick
.
Relevant Pages
- Re: Adding multiple Office References
... Rick - this did work. ... created of my Access application I created a reference to Excel for ... 2002 on their machines - so the reference that I have for Excel 2003 ... I distribute the application with a wise installer. ...
(microsoft.public.access.formscoding) - Re: Formatting numbers
... a variable containing the worksheet name or a variable containing a reference to the worksheet? ... Where you would change the column reference to suit your needs and preface it with a worksheet reference. ... Rick (MVP - Excel) ...
(microsoft.public.excel.programming) - Re: VS2005 vb.net DLL - interop EXCEL
... where you are actually working with Excel via ComInterOp ... .NET CLR to release it's reference to the underlying COM object: ... Dim xlAppl As Excel.Application ... It has to do some work with Excel files, so I created a DLL in VS2005. ...
(microsoft.public.dotnet.languages.vb) - Re: VS2005 vb.net DLL - interop EXCEL
... an explicit Worksheet object reference and don't actually get a Worksheet, ... Dim xl As New Excel.Application ... 'Set up explicit Excel object references... ... xlSheet = xlSheets ...
(microsoft.public.dotnet.languages.vb) - Re: VS2005 vb.net DLL - interop EXCEL
... Dim xl As New Excel.Application ... 'Set up explicit Excel object references... ... xlSheet = xlSheets ... 'This causes the COM reference counts to go to zero and then COM will ...
(microsoft.public.dotnet.languages.vb) |
|
