I have a workbook named say "expenses" and i have macros built in. I
want to refer to that workbook name within the code but i dont know
how. I am in effect switching between two different workbooks.

I know how to refer to a cell reference within the workbook but i dont
know if the workbook named is 'stored' anywhere in order to refer to.

Hope this makes sense ?

Thanks
Darren


--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=384009