Locating the directory a workbook is stored in

Hi, I was just wondering if it possible to get excel to return the location
of the workbook that is currently in use. If so does anyone know the VBA
code to do this? Thanks.