| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Launch VBA Macro From VB
Group, I'm certainly no VB or VBA pro, but have a question that involves both. Is it possible to launch a VBA macro from VB in the form of an icon. My vision on this is, I could have these small icons or images on my desktop that perform operations that I use daily. Basically saving the time to first loading Excel and then running the macro. Why not launch Excel and then the macro from one icon. Thank you in advance. Tony -- ajocius ------------------------------------------------------------------------ ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695 View this thread: http://www.excelforum.com/showthread...hreadid=543261 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA - Launch VBA Macro From VB
Why not just create a workbook with your macro in the Workbook_Open event
and just launch it by double-clicking that file? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "ajocius" wrote in message ... Group, I'm certainly no VB or VBA pro, but have a question that involves both. Is it possible to launch a VBA macro from VB in the form of an icon. My vision on this is, I could have these small icons or images on my desktop that perform operations that I use daily. Basically saving the time to first loading Excel and then running the macro. Why not launch Excel and then the macro from one icon. Thank you in advance. Tony -- ajocius ------------------------------------------------------------------------ ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695 View this thread: http://www.excelforum.com/showthread...hreadid=543261 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA - Launch VBA Macro From VB
Excellent idea, thank you. Tony -- ajocius ------------------------------------------------------------------------ ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695 View this thread: http://www.excelforum.com/showthread...hreadid=543261 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
| How do I Launch a Macro on a different sheet | Excel Programming | |||
| Can you use an IF statement to launch a macro? | Excel Programming | |||
| auto-launch a MACRO? | Excel Programming | |||
| Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
![ajocius[_54_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
