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

    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...

    Thanks.

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

    Review http://www.ammara.com/access_image_f...er_dialog.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 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
    Posts
    2
    Got it working now using api code here:
    http://access.mvps.org/access/api/api0001.htm

    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 allenjasonbrown@gmail.com 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