passing values from access to excel

[rtiguy]

I use a command button on an Access form to open up an Excel spreadsheet
file. It does this through a Visual Basic shell command. Is there any way to
pass a value to Excel? It would use this value to run its own query to
retreive and display information related to the record that is present on the
Access form.

Thanks.

 

[Jae]

Try this
http://mvps.org/access/modules/mdl0006.htm