XLA problems

[Neil Bhandar]

Hello:

I developed a very basic tool in XLS, toolbar & menu
option.

I converted the XLS to an add-in (XLS file) but each time
I hit the button on the toolbar it opens up the orig XLS
file.

I tried renaming the orig XLS file, the macro behind the
button fails. Seems like for some reason the macro still
points to the original XLS. Any thoughts?

Thanks in advance,
-Neil

 

[Jim Cone]

Neil,

How are you referring to the add-in workbook?
Using "ThisWorkbook" works for me, something like...

MenuButton.OnAction = ThisWorkbook.Name & "!ToggleWordWrap"
(note the exclamation point)

Regards,
Jim Cone
San Francisco, CA