View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_14_] Bob Phillips[_14_] is offline
external usenet poster
 
Posts: 216
Default 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