I have an Excel template that upon opening launches a dialog box and
retrieves another workbook into Excel. If I open the first template by
retrieving it straight into Excel or double-clicking it from Explorer, then
ActiveWorkbook.Path gives its location on disk, which I can then use to
retrieve the second template from the same folder. However, if the file is
opened using the New Task Pane in the "New from Template" option,
ActiveWorkbook.Path contains "". Is there any way to determine the original
path from which a new workbook was created?

Thanks,
Mike Thurgood