Set The Directory to the Current WB Path
 

how can I set the path to be the same as the current
workbook path?

Thanks

Set The Directory to the Current WB Path
 

thisworkbook.path


Cesar Zapata




Richy wrote:

how can I set the path to be the same as the current
workbook path?

Thanks

Set The Directory to the Current WB Path
 

ChDir ActiveWorkbook.Path
ChDrive ActiveWorkbook.Path

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Richy" wrote in message
...
how can I set the path to be the same as the current
workbook path?

Thanks