Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 08:32 PM
Macros disappear after a file is imported Brent E Excel Discussion (Misc queries) 1 December 18th 04 12:25 AM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 07:10 PM


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"