Thanks to the various kind people who have been helping me along these last few weeks. With all the packages I'm developing, I'm quite close to a final version.
Because I cannot rely on the end user not changing spreadsheet names and locations, and I have various macro calls that need to remember what the package name is, I'd like a 'volatile' package handling routine.
I've got as far as using ThisWorkbook.Path and ThisWorkbook.Name quite successfully and can store them as a public variables with no problem.
Where I hit a snag is working out the way of using this variable in an Application.Run routine.
How do I change the statement...
to use a variable declared as BookName instead of TestBook.xls? I get lost with the quotation marks!