View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christoph Lutz Christoph Lutz is offline
external usenet poster
 
Posts: 6
Default template path for active workbook?

Hi there,

I have searched high and low but no joy - maybe it's not possible?

I need to find out the path of the template (xlt) for the currently
opened workbook. I need that path because I need to refer to folders
that are relative to the current workbook's template path. That path may
change so hard coding is not really an option.

Something like ActiveWorkbook.AttachedTemplate.path doesn't exist but
gets you the idea of what I'm after....

Anyone??

Thanks so much

Christoph