Pulling the last 6 characters out of the filename

  • Thread starter Thread starter John Brenner
  • Start date Start date
J

John Brenner

I've got the right file open and all my numbers are crunching nicely - but I
need to drop in the date of the "data conversion" which is contained in the
last 6 characters of the filename.

How do I pull those last few characters out of the filename and drop it into
my string?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying worksheet into another worksheet 2
Filename creation problem in macro 4
Excel 2000 58 character Filename Limit? 8
Pulling text from the right end of a string 6
Excel VBA - Identification of illegal characters in filenames 1
Append worksheet to another inside a directory 2
FileFormat:=xlTextPrinter saves only 240 characters of cell 2
Extract characters from Right of string 5

Back
Top