I made an Excel application that generates pdf's. Now I ran into problems with long path names since the generated pdf's are to be stored further down in the folder hierarchy.
I tried to generate the pdf to a temporary folder higher up in the hierarchy and then move them but Excel saw through that and refused.
I'm trying to figure out a reasonably simple workaround. Wouldn't it be possible to make a really simple piece of code in some other language that can move the file and then call that from VBA?
Bookmarks