Thank you so much for your reply. That looks great! Do I make a module somewhere in Access to house that code? Im new to this and Im not sure where to put that code to make it work.
I put it in a module and Im not sure how to make it run.
CCECIL
Last Activity: May 30 '07, 01:30 AM
Joined: May 24 '07
Location:
-
Exporting a table from Access to formatted Excel file
Hello all,
I am new to VBA and I am not very good at it. I have chosen to learn VBA for this simple reason...I can't figure out how to export an Access table into a formatted excel document.
Is there a code that will allow this to happen?
Would it be easier to import from Excel and use a Macro?
Please help! I will send money! :)
I have Microsoft Office 2003
No activity results to display
Leave a comment: