View Single Post
  #2   Report Post  
KR
 
Posts: n/a
Default

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