Thread: Obtain Path on open workbook
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ssGuru ssGuru is offline
external usenet poster
  
Posts: 63
Default Obtain Path on open workbook
OK. This works
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1)
Bracket needed to be reversed

Thanks Bob for getting me started in the right direction.

Dennis

Reply With QuoteReply With Quote