PDA

View Full Version : [SOLVED] Excel/Word/Access



mdmackillop
06-13-2016, 02:14 PM
I'm looking to create a folder in the active document folder regardless of application. Is there a "single line" solution to return the path?

SamT
06-13-2016, 02:31 PM
Me.Path
Application.ActiveWindow.Parent.Path

OK, I've used up my imagination.

mdmackillop
06-13-2016, 04:20 PM
Thanks Sam
I've discovered that CurDir does the job