I have the following code:
MyTestAddIn_v2.xlam is the name of a XLAM file. (This is not the name of the workbook containing the above code).
Would it be possible to set the add-in name as a constant or string variable somewhere in the same project and then have this constant/variable called from the Application.Run line? (My aim is to avoid hard-coding the name into this particular sub)
I have tried doing this but I quickly ran into trouble with the 's & "s. So - Is it possible to do this or not?
Bookmarks