[wotrac]

Hi

I have a bespoke workbook that only contains 1 sheet.
When it the workbook multiple spreadsheets are inserted using data from an ADO recordset.

For each spreadsheet, I want to copy the data from another ADO recordset and drop it onto the sheet, then sum each of the columns created.
Finally I want to take each of those totals and drop them into a predefined cell on the original sheet.

Can anyone help with the best way to achieve this, as I am not sure where to start.

[Kelly_in_LA]

Hi Wotrac!

I am fairly experienced with Excel and VBA macros for Excel, but I have not worked with any "ADO recordsets" before.

I still feel that I may be able to help if you first explain to me a little more about the "ADO recordset."

Could you "zip" a recordset file and upload it so that I could work with it?

To those who know the answer, I will surely sound dumb, but what exactly is the ADO recordset? Is it a file? Is is saved as "file.ado" or what kind of file extension does it have?

Are you able to OPEN the recordset FROM WITHIN EXCEL?? If so, that would make the macro writing easier.

One last thing: are you using Windows? Windows XP? I ask, because my computer is running Windows XP, so whatever solution I might design could possibly end up being specific to my set-up, you know? especially if you have a Mac. (it is possible to have Excel on a Mac, isn't it?)

Anyway, if you could zip your recordset and upload it (as an attachment in this forum), that would be great.

Or, if it has confidential info, just make a similar one with "dummy data."

[XL Guru]

Maybe Ron's info on ADO will help.

http://www.rondebruin.nl/tips.htm

Rgds,
Andy