VBA - Launch VBA Macro From VB

[ajocius]

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

 

[Bob Phillips]

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]

Excellent idea, thank you.

Tony