VBA/OLE documentation/howto request

[galorin]

I am trying to find the documentation so that I can begin writing timesheets from my application. I've got my query working right, I just need now to spit out that data, plus a few things like date range onto the spreadsheet, and end-column totals. I have tried a few things but with no luck. the code at

http://www.databasejournal.com/features/msaccess/article.php/3563671

worked mostly until I started trying to add in my custom fields. I was pointed towards OLE methods, but not sure how to go about it in VBA.

Thanks yall

 

[SoCalAccessPro]

That code you reference is pretty generic for opening a recordset and spitting the results out to excel.

For the data range, simply parametize your query.

For the formulas, it's pretty simple. Look into the Formula property of the cell object ihn Excel.

Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com