Creating an Excel spreadsheet from Access [RESOLVED]
I'm not necessarily looking for code here, so if this board is for code only, I apologize.
Basically my question is on the portability of VBA between MS products. I've got an Access 2000 database, and I'd like to take the information from a query or table (haven't decided yet) and automatically generate an Excel spreadsheet based on that information. The spreadsheet would need to be formatted a specific way, and this would all be done automatically. Is this possible?
Re: Creating an Excel spreadsheet from Access
OK, I figured it out myself. Guess I should have done about 20 minutes more research :)
Re: Creating an Excel spreadsheet from Access
Quote:
Originally Posted by Govtcheez
OK, I figured it out myself. Guess I should have done about 20 minutes more research :)
Darn straight you should've.
