Is there a way to create a desktop shortcut to an Excel file programmically in VBA? If so could you direct me to the code snippet that accomplishes it

----- Dave Peterson wrote: ----

start "C:\my documents\excel\book1.xls

And put your prerecorded macro in a general module and name it Auto_Open

You could also just create a shortcut to your workbook (on your desktop???) an
then start that, too


MS-DOS wrote
Is there a command I can use to launch excel from DOS
and also have it go right into a pre-recorded macro
thanks

--

Dave Peterso