I can open an Excel workbook from the Run box with
C:\Users\terry\Walks\WalkIndex.xlsm

But how do I add parameters so that it will then run a specific macro
please?

Terry, East Grinstead, UK

Use that workbook's Workbook_Open event to Call the macro, OR use an Auto_Open
Sub (better) in a standard module to setup what should happen when the file
opens.

Note that Auto_Open() is the *replacement* for the Workbook_Open event, and
should be companioned with an Auto_Close() Sub which is the *replacement* for
the Workbook_BeforeClose event.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion