Set The Directory to the Current WB Path

[Richy]

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

Thanks

 

[Cesar Zapata]

thisworkbook.path


Cesar Zapata

 

[Bob Phillips]

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)