Running a macro from a desktop icon shortcut

  • Thread starter Thread starter Sofia
  • Start date Start date
S

Sofia

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
 
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 (e-mail address removed)
 
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
 
Back
Top