Macro recording won't record mouse click of add-in app button

[bocabuilder]

How can I record a macro that will run an add-in application (Dymo
LabelWriter 400) to print a label? I can get the macro to select the cells I
want to print on the label but it won't record the mouse clicks required to
push the button added to the menu bar to run the label print program.

If you view the VB module you can see the code to select the cell range to
print but there is nothing in there showing the mouse clicks that were done
during recording to push the label printer button to print the label.

Windows XP SP3
Excel 2002
Dymo LabelWriter 400

Any help will be appreciated.

 

[Dave Peterson]

Maybe you can determine the name of the macro that's being run???

In xl2003 menus:
Tools|customize (just to see this dialog)
Rightclick on that icon
Choose Assign Macro

(don't change anything!)

But do make a note of the name of the macro.

Then maybe you could add this to your code:

Dim AddInWkbk as workbook
....
set addinwkbk = workbooks("name of addin here.xla")
....
your code to select the correct range.
....
Application.run "'" & addinwkbk.name & "'!NameOfMacroYouFound"

 

[bocabuilder]

Thank you for your response. I did as you suggested but there is no macro
associated with the menu button. The button I am refering to was added to the
menu bar by the label printer program (Dymo label printer). When you manually
click on this button it opens a window with printing options for the label
printer(not windows print window). The Dymo program also added a drop down
menu list where you can click on a label type and it instantly prints the
selected cells within the active sheet.

It seems as though Excel does not recognize the button/drop-down list items
added by the Dymo printer software. If you look on the Add/Remove button
list the two buttons are listed but they are greyed out.

Hope the additional info may helps.

Thanks again!

 

[Dave Peterson]

I've never seen that Dymo addin.

I don't think I can help.

Good luck.