Creating an Excel spreadsheet via Access VBA

[PSULionRP]

I have to create an Excel spreadsheet from an Access database. I know there
are lots of standard VBA code I need to invoke. Can anyone provide me a good
web site or even a book out there that would explain this and how to create
an Excel spreadsheet utilizing Access VBA???

Any help and assistance is GREATLY appreciated.

Thanks!

PSULionRP

 

[ryguy7272]

Probably the easiest thing to do would be follow this example:
http://www.bluemoosetech.com/article.php?jid=3

Then save the Macro as a Module; that will give you VBA code.

Look at this if you are new to VBA in Access:
http://www.techonthenet.com/access/tutorials/vbabasics/basics01.php

HTH,
Ryan---