PDA

View Full Version : Access Report



lcannon
03-28-2008, 01:51 PM
Is there a way to open and Access Report using Excel VBA and open the Access Report into an Excel Spreadsheet using Excel VBA????

Thanks in advance.

lucas
03-28-2008, 01:56 PM
do you mean the table?.........not the report

lcannon
03-28-2008, 02:26 PM
No, I need the report....

Trevor
03-28-2008, 09:45 PM
you post is a little confusing,
Do want to export your access report to excel, if yes I know that possable. when you open the report save it as excel 2003.xls and you can also have it auto Open after saving, you can also close the access generated report when do, I did this the lazy way of using sendkeys
if this is what your lookin to do let me know