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/t...s/basics01.php
HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"PSULionRP" wrote:
> 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