View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Macro recording won't record mouse click of add-in app button

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 wrote:

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