I know that "filename" returns the full path to an Excel file name, but is there a way to get the name of a shortcut file that points to an Excel file name? I'd like a single, configurable template file that will automatically change some SQL lookups depending on the executing (double-clicked) file name (via a lookup table). There is is currently >95% commonality across several template files and it would be nice to only have to maintain one file.
