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.
[vba]
activeworkbook.Path
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
thanks
please mark your thread solved using the thread tools at the top of the page....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
