I'd like to take an ADO recordset, and export it to a new Excel spreadsheet
and display it on the screen, allowing the user to take control of the Excel
file and do with it what as they please ... without using third party
products.

Any code syntax or suggestions would be appreciated.

Thanks in advance!

Mark

Hi,

Here are some links related to work with Excel using ADO

http://support.microsoft.com/directory/article.asp?
ID=KB;EN-US;Q195951&LN=EN-US&rnk=3&SD=msdn&FR=0&qry=HOWTO%
20from%20ADO%20to%
20Excel&src=DHCS_MSPSS_msdn_SRCH&SPR=MSALL&

http://support.microsoft.com/directory/article.asp?
ID=KB;EN-US;Q246335&LN=EN-US&rnk=8&SD=msdn&FR=0&qry=HOWTO%
20from%20ADO%20to%
20Excel&src=DHCS_MSPSS_msdn_SRCH&SPR=MSALL&

http://support.microsoft.com/directory/article.asp?
ID=KB;EN-US;Q247412&LN=EN-US&rnk=9&SD=msdn&FR=0&qry=HOWTO%
20from%20ADO%20to%
20Excel&src=DHCS_MSPSS_msdn_SRCH&SPR=MSALL&

http://support.microsoft.com/directory/article.asp?
ID=KB;EN-US;Q257819&LN=EN-US&SD=msdn&FR=0&qry=HOWTO%20from%
20ADO%20to%
20Excel&rnk=12&src=DHCS_MSPSS_msdn_SRCH&SPR=MSALL

http://support.microsoft.com/directory/article.asp?
ID=KB;EN-US;Q278973&LN=EN-US&rnk=19&SD=msdn&FR=0&qry=HOWTO%
20from%20ADO%20to%
20Excel&src=DHCS_MSPSS_msdn_SRCH&SPR=MSALL&

http://support.microsoft.com/directory/article.asp?
ID=KB;EN-US;Q295646&LN=EN-US&SD=msdn&FR=0&qry=HOWTO%20from%
20ADO%20to%
20Excel&rnk=24&src=DHCS_MSPSS_msdn_SRCH&SPR=MSALL

Val

control of the Excel