We use Processbook VBA extensively. I am trying to write a generic VBA Class that can be used in both Excel and ProcessBook. To make code maintenance easier, I really (really!) don't want to have two versions of the class, but that is my fallback plan if I need it.
It is generally fine - most of the objects I am working with are generic enough that I don't need to worry about the differences between the two versions (I'm dealing with text files and common controls, not Displays and WorkSheets). But one issue I am stuck on: I need to get the path of the current file.
in Excel, it's ActiveWorkbook.Path. In ProcessBook, it's ThisDisplay.Path.
I was trying to see if there was something generic in the Application Object or some other property that could lead me to this answer, but can't find anything. I could possibly late-bind an object based on the Application.Name, but not sure how to late bind in Processbook (can it be done?)