PDA

Click to See Complete Forum and Search --> : help with Datareport and excel

popodc
Apr 27th, 2006, 07:18 PM
how can i set the datareport1.datasource to an excel file?? is it ont object Excel App or the workbooks?? or neither? how?? thanks!
popodc
Apr 27th, 2006, 07:43 PM
/help
popodc
Apr 27th, 2006, 08:21 PM
datareport1.datasource = ?? "i need to know on how to set it to an excel file"

please help!!
d3gerald
Apr 27th, 2006, 08:58 PM
you need to open a recordset connected to the excel file that you have

see the attached link for inforation about connecting a recordset to an excel file

http://vbforums.com/showthread.php?t=394651

then set the datasource of your report to your recordset

set DataReport1.DataSource = myRecordset
Hack
Apr 28th, 2006, 06:24 AM
Moved to reporting section