how to launch excel macro from desktop

You can accomplish this by inserting the name of the macro you want to run when the file opens into the Workbook_Open event in the This Workbook object in the VBE. (One more time in English???)

If your macro that you want to run is called "MacroStart" go to the VBE (Visual Basic Editor ... see signature below for instructions), double click the "This Workbook" object, in the drop down box at the top of the screen that has "General" in it select "Workbook". The "Workbook_Open" sub will be automatically populated for you as below. Insert the name of your macro in there.

Please Login or Register  to view this content.

Be sure to include code in your macro that will save the file (if that is what you want it to do) and then close the file. Now any shortcuts (to place a shortcut to the file on your desktop, right click the file and select "send to desktop (create shortcut)") on the desktop to this file will run your code upon opening the file and then save and close itself.

Originally Posted by mixel

Hi folks,
I have a macro that works fine in a worksheet in Excel. Instead of opening the Excel file and click on the macro, I want to place it a shortcut key on the desktop. If users click this buttion, that button should open the Excel file and start the embedded macro automatically and close the files at the end.
Is it possible using VB code? I searched the forum, but unable to find similar references.
Any help/reference is appreciated.
thanks

Do you want the workbook saved before it closes, and how do you want it saved?

A macro cannot be run without the workbook that contains it being open and macros enabled.

A macro cannot be run without the workbook that contains it being open and macros enabled.
__________________
Hope that helps.

RoyUK

Placing a shortcut icon on the desktop to open a specific workbook answers the first part of the question, when clicking that Icon to open that workbook, you are in fact running a specific macro.

Originally Posted by davesexcel

Placing a shortcut icon on the desktop to open a specific workbook answers the first part of the question, when clicking that Icon to open that workbook, you are in fact running a specific macro.

Agreed, but the user will need to Enable macros and I think from the original question that the OP thinks to automatically run the macro from the Desktop, not have to open the workbook.

Originally Posted by royUK

Agreed, but the user will need to Enable macros and I think from the original question that the OP thinks to automatically run the macro from the Desktop, not have to open the workbook.

Very good point, didn't even think about enabling macros

Thanks a lot Excelenator. You'r brilliant code worked perfect.
Thanks for the intuitive ideas of davesexcel and royuk.

I added the following code at the end of macro, so the file closed without saving it, so users can repeatedly use it.

Please Login or Register  to view this content.

jimj,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.