Is there a way of doing a macro of VBscript that you can select what folder
that contains your .xls files and save it into a variable?

explanation,

macro 1 = specify path to all .xls files
macro 2= copys cells A1- A7 from all .xls files in that folder

I've got the second macro worked out thanks to Ron de Bruins site but i cant
really get a working macro to specify a workpath easy.

Another alternative is that you could write the path inside a Cell and then
the macro claims that line, but i dont know how to do this either.