Results 1 to 2 of 2
  1. 05-10-2011, 03:02 PM #1
    BigCat's Avatar
    BigCat
    BigCat is offline Vice Pres. of Napping
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    Box Canyon
    Posts
    52

    Question Is this Possible?

    It has been a very long time since I did anything with VBA, and so I was curious if it could be programmed to query a table and then take that query and push it straight into an Excel spreadsheet.



    Is this possible?

    If anyone has a good link to a source that shows how this might be possible or could share some general code that would put me in the right direction that would be really helpful.

    Reply With Quote Reply With Quote
  2. 05-10-2011, 04:43 PM #2
    alansidman's Avatar
    alansidman
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    You can use VBA and the transferspreadsheet function to export the query directly into Excel.

    Alan
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums