View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How to find file-path of open workbook?

Do you know VBA? If so, in the immediate window type

?ActiveWorkbook.Path

and press Enter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Larryq22" wrote in message
...
Sometimes when I return to an Excel workbook that's been open for a while,
I
need to check it's path. I've been doing a file...save as and looking
there,
but I'm thinking there must be an easier way. Is there something I'm
missing?

Thanks,
Larry