I have a process which produces an excel spreadsheet of results.

The process also sends an Email out to one or more users.

I have been asked to include a link on the Email for the recipients to
click, which will open up the results spreadsheet and kick off a macro.

I know that using the following format will allow me to include a link
to a file.

<file:c:\Documents\data.xls>

I have found the following thread which gives me the code to retrieve
the Command Line Parameters,

http://www.vbforums.com/showthread.php?t=366559

How can I pass a Command Line Parameter in the link?

Alternatively, is it possible to include a button on the Email which
would run a macro which populates the fields on the spreadsheet?