Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro recording won't record mouse click of add-in app button
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro recording won't record mouse click of add-in app button
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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro recording won't record mouse click of add-in app button
I've never seen that Dymo addin.
I don't think I can help. Good luck. bocabuilder wrote: 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" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut menu won't appear when I click right mouse button. | Excel Discussion (Misc queries) | |||
How to change action of double-click left mouse button? | Excel Discussion (Misc queries) | |||
Need help with recording a macro, attaching a button | Excel Worksheet Functions | |||
double-click mouse button not working | Excel Discussion (Misc queries) | |||
Run Macro on Mouse Click | Excel Worksheet Functions |