Hi I have a problem with Excel that I would like to use a Macro to do.
I am unfamilar with the syntax used in Excel so this task is proving
to be somewhat tricky.

I would like to copy all entries from one colum into a text file.
Additionally, I would like to copy these files in such a way that I
can use those files as directory names. For example, if the value in
one of the column cells was "example", I would like to copy that value
as "/value".

I would also like the macro to automatically detect how long the
column I am copying from is, so that instead of having to specify a
range, the macro can be used in any file and it will automatically
detect from what range the columns must be copied from. The only thing
I would specify would be the column (which I would change int eh
macro).

How would I go about writng a Macro to perform such a task?

Thanks