Hi everyone! there's a customer requirement for a report in excel format and they already have a template for the report... I have set up data logging to odbc database (sql) and i can already see the data in sql...
the question is:
1. How do I send Data1 to "Excel File/worksheet1/Cell C,10" for example?
*the report is customer generated by specifying the date of the report.
i have scoured this forum for some examples but so far all i have seen is copying the whole database to excel; this is not possible with their report format so i need to put specific tag values to specific excel worksheets and cells. I do not have much experience in visual basic or sql queries but am much willing to learn.
any suggestions is most definitely welcome. TIA!
the question is:
1. How do I send Data1 to "Excel File/worksheet1/Cell C,10" for example?
*the report is customer generated by specifying the date of the report.
i have scoured this forum for some examples but so far all i have seen is copying the whole database to excel; this is not possible with their report format so i need to put specific tag values to specific excel worksheets and cells. I do not have much experience in visual basic or sql queries but am much willing to learn.
any suggestions is most definitely welcome. TIA!