R
Robert
I am creating multiple worksheets in a single workbook.
The workbook is being created by another application (Data
Junction). Each worksheet has the same columns, but the
number of rows within each sheet are dynamic.
Additionally, the number of worksheets and number of rows
per worksheet will vary on a monthly basis.
I am looking to imbed the sum function immediately after
the last record in each worksheet. While I could capture
the totals from the Data Junction conversion, my
preference would be to have Excel calculate the totals for
control purposes. In addition, I would also like to
perform some supplemental formatting (freeze panes and
decimal precision) to each worksheet.
Data Junction does support ActiveX objects, so I am
thinking that I can pass the various formatting commands
concurrent with my conversion. Can anybody point me to a
quick reference for the various ActiveX commands that I
may need?
The workbook is being created by another application (Data
Junction). Each worksheet has the same columns, but the
number of rows within each sheet are dynamic.
Additionally, the number of worksheets and number of rows
per worksheet will vary on a monthly basis.
I am looking to imbed the sum function immediately after
the last record in each worksheet. While I could capture
the totals from the Data Junction conversion, my
preference would be to have Excel calculate the totals for
control purposes. In addition, I would also like to
perform some supplemental formatting (freeze panes and
decimal precision) to each worksheet.
Data Junction does support ActiveX objects, so I am
thinking that I can pass the various formatting commands
concurrent with my conversion. Can anybody point me to a
quick reference for the various ActiveX commands that I
may need?