The problem most likely stems from the fact that @noisneil's macro uses the Custom HTML Prompt action and because that is built on WebKit it can only work with "local files".
Have a look at the following threads - I know they refer to image/icon files, but the problem seems to affect accessing files that are not on the built-in drive.