How to Open Excel thru VB/VBA please

[mrxdotcom]

I would like to send the results of my recordset (i.e Access records) to Excel but everytime i send it to Excel, it opens a new Excel application. Can anyone tell me how to send it to Excel without launching another Excel applicationand how to launch/open Excel if it's not running already. for example,

if OpenExcel = true then
send the data to Excel
else
Open Excel Application
send the data to Excel
end if


Many thanks

 

[Mile-O]

Here's a link to a recent thread:

Click here