Workbooks.Open ThisWorkbook.Path & "\" & a & ".xls"

HTH,
Bernie
MS Excel MVP


"madbloke" wrote in message
...

That did the trick.

I had to add the folder path to it, though. Is there any way of making
it relative (i.e. it works wherever the files and master sheet are
saved)?


--
madbloke
------------------------------------------------------------------------
madbloke's Profile: http://www.excelforum.com/member.php...o&userid=14422
View this thread: http://www.excelforum.com/showthread...hreadid=392477