Results 1 to 2 of 2
  1. #1
    BettyJordan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2012
    Posts
    2

    RunSavedImportExport file exists


    I created a Maco using RunSavedImportExport this works but if the file exists I the the pop window file exists is is ok to replace. I don't want to have any prompts is there a way to always replace file if it is there?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    I use only VBA, don't know if there is macro equivalent. Review http://www.rondebruin.nl/folder.htm

    I use this code to copy/replace file:

    Set objFSO = CreateObject("Scripting.FileSystemObject")
    objFSO.CopyFile "sourcepath\filename", "destinationpath\", True
    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.

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

Similar Threads

  1. RunSavedImportExport
    By rich in forum Import/Export Data
    Replies: 4
    Last Post: 03-14-2013, 02:54 PM
  2. Replies: 1
    Last Post: 06-26-2012, 03:06 AM
  3. Checking beforehand whether a file exists
    By Ronald in forum Programming
    Replies: 2
    Last Post: 07-27-2011, 08:48 AM
  4. DoCmd.RunSavedImportExport file name
    By svcghost in forum Import/Export Data
    Replies: 6
    Last Post: 02-08-2011, 08:05 AM
  5. How to tell if a file exists and then delete it
    By orcinus in forum Programming
    Replies: 3
    Last Post: 05-17-2010, 05:15 PM

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