Report in datasheet view

[pablavo]

Hi There,

Just as the title suggests, is there a way to open a report in Datasheet (Basically a query view).

I'd just set up a query, however, I need to put underlying code into the report so that I can automate opening other objects when the report closes.

I also need it to be in the form of a query so that people can cut and paste it into Excel?

Does one of the methods do this?

Thanks

 

[pablavo]

Thanks Pat, that's actually good to know since the cell range goes strait along a line within the excel template. I noticed the cell range can be specified with the method

Cheers