Running excel spreadsheet macros from access form

[warner]

I need to run a excel spreadsheet macro from access. I have managed to open the spreadsheet and start the macro. However the macro launchs an input form, which Ineed to send values to and then activate the run button. Any ideas on how to do this?

I have coded the opening of the spreadsheet and launching the macro through both a DDE connection and creating a Excel Object. So any ideas in either format of how to o the above would be great.