Re: Filename as Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

That's "almost" it. Works if I save as an XLS first, but never gives a value
if it remains a text file. "cell (filename) " would work except it is the
full path instead of just the file name. I was hoping there was a VB function
that just says "insert the filename without the extension as text here"
I do appreciate your time though.


"Tom Ogilvy" wrote:

> Range("B1").Value = left(activeworkbook.Name,len(ActiveWorkbook.name)-4)
>

.

Relevant Pages

  • Re: Open a closed workbook with VBA
    ... Regards, ... Tom Ogilvy ... > filename and it works in the open code which I have printed below. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: csv file with special separator
    ... > I doubt there is any way to redefine the separator for just one file ... > Tom Ogilvy ... >> I have file with special extension and i would like to associate this ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • String code required please
    ... Does someone have the Python code to pull just the filename and ... extension from the end of an absolute path please. ... Prev by Date: ...
    (comp.lang.python)
  • How to get filename from path, with or without _splitpath?
    ... I need to get filename and extension from a path. ... But MSDN warns about buffer over runs in splitpath ... Prev by Date: ...
    (microsoft.public.vc.language)
  • Re: Random filenames
    ... >> extension must remain the same for each filename returned. ... You still need to change the extension than, iirc there is a changeextension ... Prev by Date: ...
    (comp.lang.pascal.misc)