CurDir does not return the present working directory of the
work book. How to get the present working directory of the
work sheet

Assuming that the code is in the workbook that you're trying to lodate, use
ThisWorkbook.Path.

HTH

Alan Perkins

"vi_sh_wa" wrote in message
...
CurDir does not return the present working directory of the
work book. How to get the present working directory of the
work sheet

The folder where the active workbook resides is
ActiveWorkbook.Path

HTH. Best wishes Harald

"vi_sh_wa" skrev i melding
...
CurDir does not return the present working directory of the
work book. How to get the present working directory of the
work sheet