Set The Directory to the Current WB Path

  • Thread starter Thread starter Richy
  • Start date Start date
R

Richy

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

Thanks
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message 1004 2
Import multiple workbooks to current workbook in specified row number 0
Transpose & reorg data from 2 WS to new WB 2
Active or current file path 9
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Move one ws to new wb. Save new Wb with same but modified name as original WB 2
Help with paths 2
Active Workbook Path 2

Back
Top