[dba-VS] automating Excel

[Doug Steele]

I do this from some of my Access dbs.  Would VBA code samples be of any use?

I generally use one of two different techniques:
1. Have a pre-formatted template worksheet in Excel, which I then open,
push the data into it, and save under a new name.
2. Create a blank worksheet, fill it with the recordset data, then do all
necessary formatting in code.  This is a lot fussier, but more flexiblel.

Doug


On Mon, Dec 14, 2015 at 6:21 AM, John Colby <jwcolby at gmail.com> wrote:

> I need to add some Excel automation to my C# application.
>
> Currently I run a set of queries by hand, then take the resulting data
> sets, insert sheets into workbooks, and insert the data into the sheets.  I
> have to manually rename the pages to reflect the data set (geo location).
> About 8 sheets total, and about three different workbooks. I then close the
> workbook just created, attach to an email and email to my client.
>
> I am looking for experience, code samples, web pages to read etc. Are any
> of you folks doing this?
>
> --
> John W. Colby
>
> _______________________________________________
> dba-VS mailing list
> dba-VS at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vs
> http://www.databaseadvisors.com
>