Can you advise me as to how I should use debug.print as I haven't used it
before?

In the VB editor. open the "Immediate" window (Ctrl+G). Anything
printed using debug.print will appear there. You could try copying and
pasting the generated filepath and using it as a literal string in your
code.

Tim