Exporting a selection to a text file using a filename specified in a cell?

Hi Experts,

I'm not the biggest forum search expert so I might've missed it if it was asked before. Here's the deal; I need to export some parts of the excel sheets to a text file, which is easy enough, something like:

Please Login or Register  to view this content.

Notice how I save it as 'car_1.hdv' and 'car_2.hdv', also in a subdirectory of the same name. now I don't really want it to be named like that. Instead, I'd like to type in a cell, say A1: ''BMW'' and in A2 ''porsche''.

Now I want the files to be saved as
\physics\bmw\bmw.hdv
\physics\porsche\porsche.hdv

instead of
\physics\car_1\car_1.hdv
\physics\car_2\car_2.hdv

I can't figure out how to do this though! Any ideas?

Thanks!
/Niels

Hi Dav,

I'll try that out this weekend and will reply my luck. Thanks!
Niels

That does the job

Thanks,
Niels