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?
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?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Me.Path
Application.ActiveWindow.Parent.Path
OK, I've used up my imagination.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Thanks Sam
I've discovered that CurDir does the job
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'