Calculate Totals in Spreadsheet

[jovii]

I have a query that is being exported to a Excel spreadsheet. I am
using the VBA Docmd.TransferSpreadsheet command to export the
spreadsheet.

The users will then open the spreadsheet and use the autosum function
to get a total for 2 columns. A request was made to have these 2
columns with the totals already in place when the spreadsheet is
opened.

Is there any way in Access that I can open the spreadsheet and somehow
the totals for the 2 columns?

Any help is greatly appreciated.

Thank You,

Joe V

 

[Douglas J. Steele]

You'll have to use Automation.

See whether my July, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access" magazine is enough to get you going. You can download the
column (and sample database) for free at
http://www.accessmvp.com/djsteele/smartaccess.html

 

[jovii]

Thanks, your article is exactly what I'm looking for.