Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: VBA to export to excel sheet

    How would I go about exporting a query to a excel document to a specific range and sheet?

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by Jay59
    How would I go about exporting a query to a excel document to a specific range and sheet?
    Hi Jay59,

    Have you tried going into Excel, and placing the cursor in the cell you want the data to go and then go to: Data, then Import External Data, then Import Data and find the Access Database and Query of your choosing and pull in the QueryData that way? Just a quick and easy way to do it.

    have a nice one,
    BUD

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    have a look in the sticky code bank - pootle posted a ton of examples manipulating XLS from A

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Sep 2006
    Posts
    162
    Will do thanks.

Posting Permissions

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