View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
md[_2_] md[_2_] is offline
external usenet poster
 
Posts: 7
Default vba, get filename of this workbook

On Mar 28, 8:46 pm, md wrote:
I running a vba script inside a workbook. How do I get the complete
path to the workbook and name in which this script runs?

Thanks


ActiveWorkbook.Path + '\' + ActiveWorkbook.Name (that was easy)