Exporting data to excel with Pagebreaks and subtotal at the end of Page break

[drunkenneo]

This is to know i have an excel report generated by Access VBA, It need to appear in excel with above address and below signature.

Since i am doing this new, exactly i want to know in situattion like this what do i need to take care, becoz there is pagebreak in report with subtotals and end page have grand Total. If reports appear to be fit in 3 or more page the 2nd ...page have all the values only.



How do i process for such situation?

[drunkenneo]

[drunkenneo]

Any One??? Who can suggest a way...

[ssanfu]

Not quite sure what you are asking

I have a report that I export the report record source, then, in code, I opened Excel and modified the spreadsheet.

To create the code to modify the spreadsheet, I recorded a "macro" (code) in Excel, then adapted it to work in Access VBA. This is called Excel Automation.
here is an example of using Access to control Excel:
http://www.microsoftaccessexpert.com...utomation.aspx