Excel 2003 - I can't seem to capture the path of the current workbook. My
workbook is located at ...\My Documents\Temp Forms\ but

MsgBox ThisWorkbook.Path returns ...\Microsoft\Excel\XLSTART
and
MsgBox ActiveWorkbook.Path returns nothing

I'm trying to save one worksheet of a workbook in the "same" directory
(whatever that happens to be at a given time). The saving part of my macro
works, but the path part doesn't.

Thanks in advance for your help.