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

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

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