Results 1 to 4 of 4

Thread: Exporting help

  1. #1
    Join Date
    May 2012
    Posts
    7

    Red face Unanswered: Exporting help

    Hi everyone
    I'm wondering if you can help me. I'm using a macro to export a query into excel when i click a button in a form, which works perfectly, however when i export the query it re-names the tab in excel (for example from Sheet1 to qry_d1Export) How do i get it to keep the tab named as Sheet1?

    Thanks for any help

    Le

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Try to do it in VBA, via OutputTo Method.
    DoCmd.OutputTo..............

  3. #3
    Join Date
    May 2012
    Posts
    7
    I've not used VBA before

  4. #4
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Send a short example of your MDB, (Access2000 or 2002-2003).

Tags for this 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
  •