I used the following;

Dim BLABLA
BLABLA = ActiveWorkbook.Name 'records the file name if it ever
changed.
MsgBox "sdfsags " & BLABLA
Workbooks(BLABLA).Activate

I have a problem with putting a variable as the particular workboo
name.
I'm just wondering if this is the right syntax.

Workbooks(BLABLA).Activat

--
BrownTin
-----------------------------------------------------------------------
BrownTing's Profile: http://www.excelforum.com/member.php...fo&userid=3491
View this thread: http://www.excelforum.com/showthread.php?threadid=56291