ActiveX Control - Spreadsheet (1 Viewer)

[accessman2]

Hi

I added a activex control - spreadsheet on the form, then, I want to use copyfromrecordset function to paste qry to the spreadsheet, but it doesn't work.
So, here is a question. Does activex control - spreadsheet allow to use copyfromrecordset function?

Thanks.

 

[tranchemontaigne]

This isn't what you asked for, but it has proved helpful to me...

http://zmey.1977.ru/Access_To_Excel.htm

The article explores several different methods for exporting data to MS Excel including an ADO technique using the MS Excel reference library.
________
SUZUKI GS400E