SyntaxFix
Write A Post
Hire A Developer
Questions
It would seem likely that the ActiveWorkbook has not been saved...
Try CurDir() instead.
CurDir()