Re: Select specific text in cell

Tech-Archive recommends: Fix windows errors by optimizing your registry

Sorry, but I am not up to speed on my RegEx yet... would that retain the
c:
from the front of the path or not?

If there were no "\" after the C:, then it would be retained. But if the
C:
represents a drive, is C:filename legal? OR must it be C:\filename

Yes, c:filename is legal. In the flurry of postings we have done, you missed
my 2:40PM (EST) message. I am repeating it here so you don't have to look
for it... see my test() subroutine and note in particular the path/filename
used in the Open statement.

Expanding -- it would certainly be possible for a parser in which the "\"
preceding the filename was optional

Which is, of course, a possibility; though, in today's type file
referencing, somewhat rare. If the default path is at the directory where
the file is located, then you can legally specify the file using something
like this... c:filename.ext and the operating system will look in the
current directory. On my system, there is a directory called TEMP at the
root level of my C: drive. In that directory is a file named Test.txt. The
following code (showing a 'backslashless' path reference) prints the first
line of the file into the Immediate window...

Sub test()
ChDir "c:\temp"
Open "c:test.txt" For Input As #1
Line Input #1, LineOfText
Close #1
Debug.Print LineOfText
End Sub

Rick

Well, as written, the regex would retain the C:.

If you wanted to return filename without the C:, it would be a simple
alteration in the regex:

re.Pattern = "([^\\:]*\S)\s?-[^\\]*$"

This is a bit more robust, though:

re.Pattern = "([^\\:]*\S)\s*-[^\\]*$"

I wouldn't worry about it. Even though it is legal to have a path with no backslashes, almost no one does so anymore as it requires some mechanism to change the active directory path in order to use it. One would hardly store paths in that format with the requirement that to use them, a certain path has to be made active.

Rick

.

Relevant Pages

  • Re: Select specific text in cell
    ... c:filename.ext and the operating system will look in the ... following code (showing a 'backslashless' path reference) prints the first ... End Sub ... Well, as written, the regex would retain the C:. ...
    (microsoft.public.excel.misc)
  • Re: Select specific text in cell
    ... see my testsubroutine and note in particular the path/filename used in the Open statement. ... c:filename.ext and the operating system will look in the current directory. ... The following code (showing a 'backslashless' path reference) prints the first line of the file into the Immediate window... ... End Sub ...
    (microsoft.public.excel.misc)
  • Re: How do I get rid of MSAccess in Warning boxes
    ... Some errors need to be handled by the operating system. ... easily handled by adding error handling. ... Sub Whatever ... > open How do I stop the MsgBox Identifying the ...
    (microsoft.public.access.forms)
  • Re: OnKey and Range Question
    ... Dim rng As Range ... End Sub ... combination based on the operating system ... I was also wondering how to make 'onKey' work for both Mac and PC. ...
    (microsoft.public.excel.programming)