Consulting

Results 1 to 4 of 4

Thread: Access Report

  1. #1

    Access Report

    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.

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    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

  3. #3
    No, I need the report....

  4. #4
    VBAX Mentor
    Joined
    Dec 2007
    Posts
    462
    Location
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •