View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Stefan Mueller[_2_] Stefan Mueller[_2_] is offline
external usenet poster
 
Posts: 20
Default How to get the current path

ActiveWorkbook.Path is closer to my wanted function than CurDir
because it shows e.g. 'C:\Documents and Settings\Administrator
\Desktop' if I start the Excel workbook from the Desktop.
However, it doesn't show 'C:\Temp' if in 'Start in:' of the shortcut
of the Excel workbook is written 'C:\Temp'.