For what it's worth, I finally figured out what was happening- apparently if
the module name and the sub name are the same, XL feels the need to include
the whole path. I modified the name of my module slightly, and now I just
have the macro name in all cases.
The first two macros show up in the macro list [tools/macros/macros] with
just the macro name, e.g. <TransferData.
But the most recent macro I made shows up with the entire filename, e.g.
<'My File Name.xls'!BackupData.
Keith
|