Hi all,
I have a macro which imports a selection of files to the active
worksheet (one after another). It does the job fine. The text files
are named as follows: B1020607.txt - where the last 6 digits are the
date of the file.

I need (somehow) for the first column in my worksheet to display the
date of the worksheet - to extract it somehow from the filename and
place it in the relevant places.

The macro to import the text files can be read at this location
(Thanks to Ron):
http://groups.google.co.uk/group/mic...339530d?hl=en&

If anyone can help with this problem it will be greatly appreciated.

Thanks in advance,
Scott.