Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro from a desktop icon shortcut
Hello.
I have a macro written in my workbook. I want to run it by clicking on an icon on my desktop without having to open MS Excel. I know this can be done in MS Access. Also, I used the Shell function to run an .exe with a '0' argument so it will be hidden. Do I have to end it or close it or will it do that by itself when the .exe finishes running? -Sofia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro from a desktop icon shortcut
Sofia,
Try writing a VB Script file containing the following: Dim XL Dim WB Set XL = CreateObject("Excel.Application") Set WB = XL.Workbooks.Open("C:\Book1.xls") XL.Run "TestMacro" WB.Close XL.Quit Set WB = Nothing Set XL = Nothing Put this script file on you desktop. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sofia" wrote in message ... Hello. I have a macro written in my workbook. I want to run it by clicking on an icon on my desktop without having to open MS Excel. I know this can be done in MS Access. Also, I used the Shell function to run an .exe with a '0' argument so it will be hidden. Do I have to end it or close it or will it do that by itself when the .exe finishes running? -Sofia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro from a desktop icon shortcut
I tried your VB script and works wonderfully except for one detail. Every time I run the script, after it is done, it pops up a 'File Available for Use' window telling me that my excel file is available for editing giving me the option to open it as 'read/write' or 'cancel'. It's doing this everytime. Is there a way to shut this off? Other than this, I've run the script multiple times and works just fine. -Sofia *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I put an icon for Desktop in Quick Access? | Excel Discussion (Misc queries) | |||
Shortcut key not running macro properly | Excel Discussion (Misc queries) | |||
Desktop File Icon | Setting up and Configuration of Excel | |||
dragging a file to the desktop icon | Excel Discussion (Misc queries) | |||
how can i put the excel icon on my desktop? | Excel Discussion (Misc queries) |