Output Access Data to Excel

[dsatino]

Ok, I admit there's info on this out there already but it's kind of scattered and usually specific to a problem, so stick with me for a second. I'm not looking for any specifics, just generally how to go about the following:

From Access VBA I need to:

Launch Excel
Create a new workbook
Create worksheets
Move around the worksheet cells
Edit cells

If anyone can give me any library references and/or general methods that would be great.
Thanks

[NeoPa]

Have you considered Application Automation?

[dsatino]

That'll work for getting started thanks. I'm sure i can figure out the all moving around and formatting as I play with the library.

Thx!

[NeoPa]

No worries. I'm pleased I could help you, especially as you've contributed so much here recently :)

[dsatino]

No problem. It wouldn't be fair to ask and not answer where I could.

[NeoPa]

I think you've more than done your fair share, but we like that, so don't stop now :D