how can i set the datareport1.datasource to an excel file?? is it ont object Excel App or the workbooks?? or neither? how?? thanks!
Printable View
how can i set the datareport1.datasource to an excel file?? is it ont object Excel App or the workbooks?? or neither? how?? thanks!
/help
datareport1.datasource = ?? "i need to know on how to set it to an excel file"
please help!!
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
Moved to reporting section