Export to Excell / New tabs

[Sprawl]

Hi Y'all. Long time no ask, But hopefully you can help me on this.

I've got a report written. looks good. Works good. Everythign is exactly as I wanted it.

However the question is now they want it exported to Excell format. But the kicker.

Each page must appear in the excell spreadsheet as a new tab (named after the sorting group)

is this possible?

 

[boblarson]

Hi Y'all. Long time no ask, But hopefully you can help me on this.

I've got a report written. looks good. Works good. Everythign is exactly as I wanted it.

However the question is now they want it exported to Excell format. But the kicker.

Each page must appear in the excell spreadsheet as a new tab (named after the sorting group)

is this possible?

It's possible but it will take using the Excel COM Object model to do so.

 

[Sprawl]

thanks bob,

I'm not aware of the excel COM module though. I'll need to look into it

 

[boblarson]

Model, not module.

Google for

Dim objExcel As Object

or

Set objExcel = CreateObject("Excel.Application")

and you should see lots of examples.