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.
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.
do you mean the table?.........not the report
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
No, I need the report....
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