View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] norm@shaw.ca is offline
external usenet poster
 
Posts: 1
Default How to extract file name for use in a cell?

Hi, Using XL2002 and Windows 2000

If I have a file named A00015249CR.csv and I want to
place the first 11 characters of the filename in a cell, how
would I do that, if it's possible.

What I need to do is run several scripts on files that return simialr
data, so inserting the filename into an inserted column at the left
of each dataset would allow me to combine the data into one file
and still know where each row of data originated.

Thanks in advance!

Norm