VBA Access 2000 Outputting MS Access reports to excel?

[dangercat]

Hello,

I want to output 3 reports (Budget, Forecast, Sales) to 3 different sheets in the one excel file (Accounting).

Can anyone please help me with this?

Thank you.

[OBP]

dangercat, welcome to the Forum.
You can probably use the "TransferSpreadsheet" command to do this, but it might be even better to open Excel and "Link" to the underlying queries that supply the Reports with their data. That way the data will always be Up to Date.
There are quite a few Threads on here about doing what you want, you can use the "Search" facility to find them.

[Movian]

Alternatively if you like to get stuck in like me you could look into office automation to produce the spreadsheet. The advantage of that is you have A LOT of direct control over the end result :)

But OBP is correct there is a lot of documentation on this.

[OBP]

Movian, you mean to say that you haven't got some already? :devil2:

[dangercat]

Thanks for the help people.

I think I will probably link the excel file to the queries.