PDA

View Full Version : Solved: Find current folder



Annodomini2
03-08-2008, 07:35 AM
Hopefully a simple one for someone to answer, i've tried searching, but I get about 2000 hits none with an obvious answer.

I'm using Excel 2000 (Work's choice not mine!!)

Anyway in VBA I want to know how to get the current folder of the calling file, can't see any obvious commands in the help, currently its defaulting to My Documents which is of no use as I need the output in the current location.

Bob Phillips
03-08-2008, 07:47 AM
activeworkbook.Path

Annodomini2
03-08-2008, 08:07 AM
thanks :)

lucas
03-08-2008, 09:16 AM
please mark your thread solved using the thread tools at the top of the page....