Anyone know MSAccess VBA??

[twizttid1]

Can anyone help me, I'm having a tough time hammering out some Access VBA...

I just want to export 2 queries to a predetermined Read-Only Excel "template" on specific tabs...

I've got a lot of experience prgramming Excel VBA.....This task seemed Easy to me.... but it's proving to be far more difficult than anticipated.....

If anyone has any experience with this, please let me know!

Thanks in Advance

Jason

[truperc]

I have found it easier to import the database from excel rather than trying to export it from access. If you bring up the external data toolbar you can import from there and any time you change the data in Access just click on the refresh all button and all your data will be updated. Hope that helps, let me know if this is unclear!!

Troy

[twizttid1]

Oh wow... I totally forgot about this thread... Thanks for you response!!! But I figured it all out...
I was designing a user-community DB tool, where they enter in a few criteria in a form, click a button and the DB would spit out the info and format it all pretty-like on an excel sheet.

For what I needed the user community to do, I couldn't start in Excel...it had to start from access.