Results 1 to 6 of 6
  1. #1
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155

    Macro to export to excel

    I am using a Macro to export queries to excel. The catch is, I want to export 4 queries to excel on different sheets all in the same workbook. Is that possible?

    Sheet 1: Report that is linked to the 4 queries via forumals
    Sheet 2: MethodofReciept
    Sheet 3: DocTypeCount


    Sheet 4: ClaimsKeyed
    Sheet 5: ReasonNotEntered

    Any suggestions?!

    Thanks in advance

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    would the code that I posted here help: http://www.access-programmers.co.uk/...d.php?t=191123

  3. #3
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    Is that to be used in a module and not a macro?

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    macros don't take code, bud.

    it belongs in a module.

  5. #5
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    I got that, but I am trying to it in a macro...is that possible?

  6. #6
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    no, I dont think it is. But I've never tried it. The reason the code was written was because I didn't believe it was possible years ago when I wrote it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macro export to excel error
    By Andy_d in forum Import/Export Data
    Replies: 7
    Last Post: 04-15-2011, 09:54 AM
  2. Import Excel File Using Macro?
    By oregoncrete in forum Import/Export Data
    Replies: 0
    Last Post: 04-05-2011, 12:26 PM
  3. Replies: 1
    Last Post: 10-15-2010, 06:09 AM
  4. Running excel macro from access
    By timpepu in forum Programming
    Replies: 1
    Last Post: 02-26-2010, 11:32 PM
  5. Export to Excel
    By vaikz in forum Import/Export Data
    Replies: 3
    Last Post: 03-25-2009, 09:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums