Results 1 to 3 of 3
  1. #1
    zapouk is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012

    Using FileDialog to export to Excel

    Access 2007.
    FileDialog for importing is fine - use msoFileDialogFilePicker to pick the full path of the file to import data from.

    But when exporting and trying to use FileDialog with msoFileDialogSaveAs it throws an error.

    Help says "The msoFileDialogOpen and msoFileDialogSaveAs constants are not supported in Microsoft Access."
    So how do you do it? Sure this is a common question and there's a work-around somewhere...


  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Need to open file browser to select folder and set a variable that can be used in code that exports. Show code for analysis.

    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    zapouk is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Got it working now using api code here:

    The only way I've found to do it.

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

Similar Threads

  1. Replies: 3
    Last Post: 10-07-2011, 07:49 AM
  2. Export table to excel using excel template
    By in forum Programming
    Replies: 1
    Last Post: 06-27-2011, 02:10 AM
  3. Trying to export to Excel
    By BigCat in forum Programming
    Replies: 19
    Last Post: 05-19-2011, 01:49 AM
  4. FileDialog
    By Tomfernandez1 in forum Programming
    Replies: 9
    Last Post: 04-13-2011, 03:45 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